Re: Oracle 9i and PublicRollback Segment

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

>

>