Re: Bypassing RBS

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 18 Feb 2000 18:45:43 +0800
Message-ID: <38AD22D7.36FC@yahoo.com>

Jerome Moinet wrote:
>
> 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!
> >

direct load insert is available from 8.0...

• set your table to nologging
• do an insert /*+ APPEND */
• use parallel read and parallel dml if you have >1 processor.

Then sit back and watch the magic... :-) --

---

Connor McDonald
http://www.oracledba.co.uk

"Beta, n: Latin for 'still does not work'" Received on Fri Feb 18 2000 - 04:45:43 CST