Re: Oracle 9i and PublicRollback Segment

Hi Ronny,

your init.ora parameter undo_management is set to auto. To use the old rollback segment management you have to set this parameter to manual

Regards
Stefan

Ronny Egner wrote:

> 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
Received on Wed Nov 28 2001 - 02:55:55 CST