RE: Create rollback segment under ORACLE 9ir2 failed????

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 13 Mar 2003 16:30:03 -0800
Message-ID: <F001.00569CA8.20030313163003@fatcity.com>

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: kirti.deshpande_at_verizon.com

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: ListGuru_at_fatcity.com (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).

Received on Thu Mar 13 2003 - 18:30:03 CST