Home » RDBMS Server » Server Administration » ORA-01552: cant use system rollback segment for non-system tablespace
ORA-01552: cant use system rollback segment for non-system tablespace [message #63141] Tue, 14 September 2004 02:23 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
rriaz
Messages: 2
Registered: April 2005
Location: India
Junior Member

Thank you very much..

Regards,
R.Riazouddine.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
BlackSwan
Messages: 25036
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.
Previous Topic: SQL session hangs when quering a table
Next Topic: possible to change required Oracle10g Memory?
Goto Forum:
  


Current Time: Sun Dec 04 02:53:12 CST 2016

Total time taken to generate the page: 0.19459 seconds