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

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

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

From: Daniel W. Fink <optimaldba_at_yahoo.com>
Date: Thu, 13 Mar 2003 15:04:55 -0800
Message-ID: <F001.00569B21.20030313150455@fatcity.com>


Mike,

    Check the setting for undo_management. It needs to be set to MANUAL.

mike mon wrote:

>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
>
>

-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  INET: optimaldba_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 - 17:04:55 CST

Original text of this message

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