Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Create rollback segment under ORACLE 9ir2 failed????
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
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 minextents20 optimal 5M);
Does anyone know why?
Thanks.
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 ---------------------------------------------------------------------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:24:46 CST