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
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
Title: 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:[EMAIL
Mike, et.al,
Mea Culpa. Please ignore my previous post. I failed to properly
context switch from my Automatic Undo mode.
IIRC, as of 7.3, the requirement for a second rollback segment in
SYSTEM was removed, with minor exceptions. I think the one that is
biting you is that a second RBS
And what Pete said does work.
Here is a report from my testing of undo mode switching (AUM - MUM). Rollback
tablespace was already created.
SQL create rollback segment rbs01 tablespace rollback;
create rollback segment rbs01 tablespace rollback
*
ERROR at line 1:
ORA-01552: cannot use system
