Oracle-L: RE: Create rollback segment under ORACLE 9ir2 failed????

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Thu, 13 Mar 2003 15:24:46 -0800
Message-ID: <F001.00569B6A.20030313152446@fatcity.com>

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.

Do you Yahoo!?
Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: mike mon
INET: mccdba_at_yahoo.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Pete Sharman
INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------