Home » RDBMS Server » Server Administration » ORA-01552: cannot use system rollback segment for non-system tablespace
ORA-01552: cannot use system rollback segment for non-system tablespace [message #61025] Sun, 21 March 2004 13:08 Go to next message
Michael Miles
Messages: 1
Registered: March 2004
Junior Member
I enabled an automatic undo management and I am trying to a create table:

CREATE TABLE customers
( cust_code VARCHAR2(3),
name VARCHAR2(50),
region VARCHAR2(5) )
TABLESPACE DATA1;

I get this error message:

CREATE TABLE customers
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'DATA1'

 

Can anyone give ideas on how to solve this problem?

 

Thanks,

Mike

Report message to a moderator

Re: ORA-01552: cannot use system rollback segment for non-system tablespace [message #61027 is a reply to message #61025] Sun, 21 March 2004 19:47 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
Drop all redo entries in UNDO segment, drop and recreate UNDO segment(under the sys account).

Report message to a moderator

Re: ORA-01552: cannot use system rollback segment for non-system tablespace [message #61040 is a reply to message #61025] Mon, 22 March 2004 04:22 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You are getting this error becos you are using automatic undo management and there is no undo tablespace defined. Create UNDO tablespace ,assign that as your UNDO_TABLESPACE and then retry creating the table.

-Thiru

Report message to a moderator

Re: ORA-01552: cannot use system rollback segment for non-system tablespace [message #61041 is a reply to message #61027] Mon, 22 March 2004 04:24 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Note that he is using automatic undo management and hence he may not be able to manually drop/create undo segments.

Report message to a moderator

Previous Topic: What is the release date for 10g on Windows
Next Topic: What is XDB in spfile.ora?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:33:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.