Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bypassing RBS

Re: Bypassing RBS

From: Dave Leather <dave.leather_at_zoom.co.uk>
Date: Tue, 22 Feb 2000 19:58:43 -0000
Message-ID: <88uqlf$ujf$1@quince.news.easynet.net>


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 - 13:58:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US