Oracle 9i and PublicRollback Segment

From: Ronny Egner <RonnyEgner_at_gmx.de>
Date: Wed, 28 Nov 2001 08:39:45 +0100
Message-ID: <9u245j$1vm$1@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 Received on Wed Nov 28 2001 - 01:39:45 CST