OraFAQ Forum: Server Utilities » Error in Rollback segment creation in 9i in a non system tablespace

Home » RDBMS Server » Server Utilities » Error in Rollback segment creation in 9i in a non system tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in Rollback segment creation in 9i in a non system tablespace [message #72435]

Sat, 14 June 2003 04:20

vivek
Messages: 59
Registered: October 2001

Member

I tried to create a rollback segment in oracle9i database after setting the value of UNDO_MANAGEMeNT parameter to MANUAL. I logged in as System user

CREATE PUBLIC ROLLBACK SEGMENT "IPMS_RBS01"
TABLESPACE "TS_TIMESHEET"
STORAGE (
INITIAL 2048K
NEXT 100K
OPTIMAL 4096K
MINEXTENTS 2
MAXEXTENTS 750)

I receive the foll. error message:

ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace
'TS_TIMESHEET'

Please help at the earliest

Thanks in advance

Report message to a moderator

Re: Error in Rollback segment creation in 9i in a non system tablespace [message #72436 is a reply to message #72435]

Sun, 15 June 2003 17:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

by default the database in 9i would be set to UNDOTABLESPACE OPTION.
Please check that.

Report message to a moderator

Previous Topic:	Archive Logs not deleted
Next Topic:	Migrate from Oracle 8.0.3 (Netware) to oracle 8.1.7 (WIN2K)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 06:57:22 CST 2024