Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Create rollback segment under ORACLE 9ir2 failed????

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

From: mike mon <mccdba_at_yahoo.com>
Date: Thu, 13 Mar 2003 14:29:36 -0800
Message-ID: <F001.00569A84.20030313142936@fatcity.com>


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).
Received on Thu Mar 13 2003 - 16:29:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US