Re: Bypassing RBS

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 Mon Feb 21 2000 - 06:07:41 CST