Re: Bypassing RBS

From: Dave Leather <dave.leather_at_zoom.co.uk>
Date: 2000/02/22
Message-ID: <88uqlf$ujf$1_at_quince.news.easynet.net>#1/1


I seem to remeber that commits inside PL/SQL dont actually release any RBS extents until the whole procedure has finished. However you could also use a create table aaa( ....) unrecoverable as select ...
but remember to do a backup after as the syntax says you cant recover it..

Jos <jga.wolters_at_abp.nl> wrote in message news:88r9o6$b63_at_sunsv007...
> Hi,
>
> There are two solutions without need for large rollback segments...
>
> Use the copy statement unser SQL*Plus where you can commit after array
> insert.
> or
> Write a little pl/sql program where can you commit...
>
> Jos
>
> Jerome Moinet <jmoinet_at_netcourrier.com> schreef in berichtnieuws
> 88jqdc$fhg$1_at_ssauraaa-i-1.production.compuserve.com...
> > Thank you for your help.
> >
> > But what i am trying to do is to load a table T1 into a table T2, T1 is
> > quite huge (let's say 3Go), using a insert into T1 select * from T2.
 What
 is
> > happening is that the RBS is too small, and i can't increase it size.
 (no
> > disk left...)
> >
> > So i would like Oracle not to use the RBS. I've been told of parameters
 used
> > in the database init file to bypass the RBS use. I just would like to
> > restart the database with these parameters, duplicate T1 contents,
 remove
> > the parameters and restart the database. This is a test database, and it
> > will be destroyed after the use i want to do with it.
> >
> > if anyone have a solution, thank you by advance.
> >
> > I'm using Oracle 8.0.6, so the 8i solution doesn't work.
> >
> > "Mario Bucsics" <mario.bucsicsNOmaSPAM_at_siemens.at.invalid> a écrit dans
 le
> > message news: 194a330b.803d4a7d_at_usw-ex0102-014.remarq.com...
> > >
> > > Sorry ,you´re right !
> > >
> > > But this work´s only in oracle8i, as i remember, an with many
> > > restrictions.
> > >
> > > Mario Bucsics,OCP
> > >
> > >
> > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion
 Network
 *
> > > The fastest and easiest way to search and participate in Usenet -
 Free!
> > >
> >
> >
>
>
Received on Tue Feb 22 2000 - 00:00:00 CET

Original text of this message