Re: Oracle 9i and PublicRollback Segment

Sorry -should have added that 'undo_management' just says you want to use the new feature. The parameter to specify which tablespace is actually to be used for automatic undo is 'undo_tablespace'.

Should perhaps have also mentioned that you can't just point that last parameter at any old tablespace: you have to 'create undo tablespace blah....' to create the right sort of tablespace to start with.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:3c04d152$0$5101$afc38c87_at_news.optusnet.com.au...


> Always include the exact error message if you want detailed help,

otherwise


> it's a question of the blind leading the blind.

>

> I'd suspect, however, that you are encountering the new 9i feature whereby

> there are no such thing as rollback segments anymore.  All you need do in

9i


> is create an 'undo tablespace', and tell Oracle to use it (with the

init.ora


> parameter undo_management=auto).  It then creates undo segments for you on

> the fly, much as it has long since created sort segments as needed in

> temporary tablespace.

>

> The full thinking behind this is explained in the 9i new features document

> available at my website (look under the 'books' link).

>

> If you really want to use traditional rollback segments, then set

> undo_management to MANUAL, and go for it.  However, quite why you'd want

to,


> I can't think.  You'll lose the protection from ORA-1555's that 'undo

> retention' gives you, flashback won't work reliably, and time spent on

> managing rollback will rise exponentially.

>

> Regards

> HJR

> --

> Resources for Oracle: http://www.hjrdba.com

> ===============================

>

>

> "Ronny Egner" <RonnyEgner_at_gmx.de> wrote in message

> news:9u245j$1vm$1_at_news.rostock.infocity.de...

> > Hi,

> >

> > I´m new to Oracle 9i.

> > In 817 i created a public rollback segment with these commands in

sqlplus:


> >

> > CREATE TABLESPACE RBS DATAFILE '/u01/oradata/SCH817/rbs01.dbf' SIZE 800M

> > REUSE

> >  AUTOEXTEND OFF

> > MINIMUM EXTENT 1024K

> > DEFAULT STORAGE ( INITIAL 1024K NEXT 1024K MINEXTENTS 4 MAXEXTENTS

4096);


> >

> > CREATE PUBLIC ROLLBACK SEGMENT LONG_RS TABLESPACE RBS STORAGE (initial

5M


> > next 5M minextents 20);

> > CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS STORAGE ( OPTIMAL

> > 4096K );

> > CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS STORAGE ( OPTIMAL

> > 4096K );

> >

> > ALTER ROLLBACK SEGMENT "LONG_RS" ONLINE;

> > ALTER ROLLBACK SEGMENT "RBS0" ONLINE;

> > ALTER ROLLBACK SEGMENT "RBS1" ONLINE;

> >

> >

> > In 9i I get an ORA-30019 while tryng to execute "CREATE PUBLIC ROLLBACK

> > SEGMENT LONG_RS TABLESPACE RBS STORAGE (initial 5M next 5M minextents

> 20);"

> >

> >

> > How can I create a public RBS ???

> >

> >

> >

> >

> > Thanks. Ronny

> >

> >

>

>