And what Pete said does work. Here is a report from my testing of undo mode switching (AUM <-> MUM). Rollback tablespace was already created.
SQL> create rollback segment rbs01 tablespace rollback; create rollback segment rbs01 tablespace rollback * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK' SQL> create rollback segment junk tablespace system; Rollback segment created. SQL> create rollback segment rbs01 tablespace rollback; create rollback segment rbs01 tablespace rollback * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK' SQL> alter rollback segment junk online; Rollback segment altered. SQL> create rollback segment rbs01 tablespace rollback; Rollback segment created. SQL> alter rollback segment rbs01 online; Rollback segment altered. SQL> alter rollback segment junk offline; Rollback segment altered. SQL> drop rollback segment junk; Rollback segment dropped. HTH, - Kirti -----Original Message----- Sent: Thursday, March 13, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Mike The only way this would have worked under 8i is if you had already created a dummy rollback segment in the SYSTEM tablespace. Something like this should work (before or after the CREATE TABLESPACE rollback_space) SQL> connect / as sysdba; SQL> CREATE ROLLBACK SEGMENT dummy; Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- Sent: Thursday, March 13, 2003 2:30 PM To: Multiple recipients of list ORACLE-L I am create database on ORACLE 9iR2 and fail on create rollback segment. SQL> create tablespace rollback_space datafile 2 '/u4/oradata/TRAN/rbs01TRAN.dbf' size 800M 3 default storage ( 4 initial 256k 5 next 256k 6 pctincrease 0 7 minextents 8 8 MAXEXTENTS 4096 9 ); Tablespace created. SQL> SQL> REM * Create rollback segments. SQL> REM * SQL> create rollback segment rollback_1 tablespace rollback_space 2 storage (initial 256K next 256k minextents 20 optimal 5M); create rollback segment rollback_1 tablespace rollback_space * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK_SPACE' SQL> create rollback segment rollback_2 tablespace rollback_space 2 storage (initial 256K next 256k minextents 20 optimal 5M); create rollback segment rollback_2 tablespace rollback_space * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK_SPACE' Those script used to work under ORACLE 8i. Does anyone know why? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
