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

I see other people have already answered your question, but would it be presumptuous of me to ask why you are using ROLLBACK segments instead of an UNDO tablespace?

> -----Original Message-----
> From: mike mon [mailto:mccdba_at_yahoo.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'

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.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).