Home » RDBMS Server » Server Administration » ORA-01552 : cannot create rollback segments?
ORA-01552 : cannot create rollback segments? [message #61970] Tue, 15 June 2004 00:40 Go to next message
Rishka
Messages: 2
Registered: June 2004
Junior Member
 

I am creating a second database on a machine

The init.ora is set as rollback_segments = (rb01,rb02,rb03,rb04)

 

The TABLESPACE RBS DATAFILE has been created, yet when trying to create a non-system rollback segment the following message appears:


CREATE ROLLBACK SEGMENT RB02

*

ERROR at line 1:

ORA-01552: cannot use system rollback segment for non-system tablespace

'RBS'


I have looked at the error documentation, and followed the instructions, but could not even create a public or private rollback segment??

The system rollback segment has been created successfully..

What am is missing that new rollback segments cannot be created..

 

 

 

Report message to a moderator

Re: ORA-01552 : cannot create rollback segments? [message #61974 is a reply to message #61970] Tue, 15 June 2004 03:15 Go to previous message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
Indicate a tablespace, where you want to create a segment in script.

Report message to a moderator

Previous Topic: end of communication channel ora:3113
Next Topic: killing sessions dynamically
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:23:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.