OraFAQ Forum: Server Administration » ORA-01552: cant use system rollback segment for non-system tablespace

Home » RDBMS Server » Server Administration » ORA-01552: cant use system rollback segment for non-system tablespace

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

ORA-01552: cant use system rollback segment for non-system tablespace [message #63141]

Tue, 14 September 2004 02:23

Vivek Vijai
Messages: 67
Registered: April 2004

Member

While trying to create a table in�the Schema in 9i db, its giving error�"ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'"

Please let me know the soln of the problem

Thanks in advance

Vivek

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #63142 is a reply to message #63141]

Tue, 14 September 2004 02:50

Rashmi
Messages: 20
Registered: April 2001

Junior Member

Hi vivek,
This error occurs if u do not have any rollback segment apart from the one in system tablespaces.

So create a new rollback tablespace and rollback segments. Or check if the other rollback segments are offline.

~Rashmi

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #63144 is a reply to message #63142]

Tue, 14 September 2004 04:37

Vivek Vijai
Messages: 67
Registered: April 2004

Member

Thanks Rashmi
I have a Undo Tablespace(running in Manual mode, status ONLINE) when i changed it to Auto, my db dont even open(Oracle instance terminated: error), so i changed back to Manual mode. Again am getting the same error. All of the tablespaces are running in MANUAL segment sp management mode.
Plez help me out

Thanks in advance
Vivek

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #63153 is a reply to message #63144]

Tue, 14 September 2004 21:36

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

pls change that parameter in init.ora file,for this shutdown the database and set undo_management = auto
in parameter file then restart the database the it will work

Regards

D.Dilip

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #146592 is a reply to message #63153]

Fri, 11 November 2005 05:51

rriaz
Messages: 2
Registered: April 2005
Location: India

Junior Member

Thank you very much..

Regards,
R.Riazouddine.

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #146597 is a reply to message #146592]

Fri, 11 November 2005 06:27

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

As Per Oracle Regarding Error ORA-01552 Smile

================================================================
ORA-01552 cannot use system rollback segment for non-system tablespace 'string'

Cause: An attempt was made to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.

Action: Create one or more private/public segment(s), shut down and restart. May need to modify the initialization parameter ROLLBACK_SEGMENTS to acquire private rollback segment. If this is a clone database being used for tablespace point in time recovery then this operation is not allowed.
================================================================

Regards
Always Friend Sunilkumar

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #307683 is a reply to message #146597]

Wed, 19 March 2008 08:40

jolly_makkar
Messages: 63
Registered: March 2008

Member

Hi,

this error is part of undo tablespace ..make your initialised parameter UNDO_MANAGEMENT=AUTO

You can do this change in pfile after than create spfile from pfile
start the database you wont get this error...cheers

Report message to a moderator

Re: ORA-01552: cant use system rollback segment for non-system tablespace [message #307685 is a reply to message #63141]

Wed, 19 March 2008 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

jolly_makkar,
why are you responding to a thread 2 - 3 years old?
You should find a more productive use of your time & efforts.

Report message to a moderator

Previous Topic:	SQL session hangs when quering a table
Next Topic:	possible to change required Oracle10g Memory?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:38:25 CST 2024