Re: Bypassing RBS

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Fri, 18 Feb 2000 17:12:31 GMT
Message-ID: <38AD7F16.D7FEDCD4@lds.com>

Can U create a large rollback segment? this is what I am doing:

CREATE TABLESPACE IMPORT_RBS

       DATAFILE '/export/home/oracle/oradata/ORCL/import_rbs.dbf' SIZE 1500M
       DEFAULT
       STORAGE (
       INITIAL 100M
       NEXT 100M
       MINEXTENTS 1
       MAXEXTENTS 121
       )

;

CREATE ROLLBACK SEGMENT IMPORT_RBS
TABLESPACE IMPORT_RBS
STORAGE ( INITIAL 100M NEXT 100M OPTIMAL 500M MINEXTENTS 2 MAXEXTENTS 121); ALTER ROLLBACK SEGMENT IMPORT_RBS ONLINE; 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!
> >

Marc Weinstock
Logical design Solutions

55 Broadway - 21st Floor
New York, New York 10006

Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com Received on Fri Feb 18 2000 - 11:12:31 CST