Home » RDBMS Server » Server Administration » ORA-01552 problem
ORA-01552 problem [message #209968] Mon, 18 December 2006 15:41 Go to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

hi all,
i've the ORA-01552 problem,
cannot use system rollback segment for non-system tablespace...
I tried to create a new table and I got this message.
what does it mean ?
How can I resolve it ?
Re: ORA-01552 problem [message #209970 is a reply to message #209968] Mon, 18 December 2006 15:55 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
The following is a quote from the Oracle online documentation:

"ORA-01552: cannot use system rollback segment for non-system tablespace 'string'
Cause: Tried 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), shutdown and then startup again. May need to modify the INIT.ORA parameter rollback_segments to acquire private rollback segment. If this is a clone database being used for tablspace point in time recovery then this operation is not allowed. If the non-system tablespace has AUTO segment space management, then create an undo tablespace."
icon9.gif  Re: ORA-01552 problem [message #210147 is a reply to message #209970] Tue, 19 December 2006 10:57 Go to previous messageGo to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

i've created an undo tablespace, but the problem still exists.

plz plz help.
Re: ORA-01552 problem [message #210220 is a reply to message #210147] Tue, 19 December 2006 20:57 Go to previous messageGo to next message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

show parameter undo

you need to set undo_tablespace to the undo tbs you created, and set the UNDO_MANAGEMENT to AUTO.
icon9.gif  Re: ORA-01552 problem [message #210406 is a reply to message #209970] Wed, 20 December 2006 12:19 Go to previous messageGo to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

i did that Sad
& i got this error:

SQL> alter system set undo_management=manual scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-00376:file 2 cannot be read at this time
ORA-01110:data file 2:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF'

plz help
thx
Re: ORA-01552 problem [message #210441 is a reply to message #210406] Wed, 20 December 2006 18:43 Go to previous messageGo to next message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

The tablespace or data file is offlined?

Or cannot be read due to IO problem?
icon9.gif  Re: ORA-01552 problem [message #210618 is a reply to message #210441] Thu, 21 December 2006 09:39 Go to previous messageGo to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

so what to do??
plz help it's urgent...
Sad

thx in advance
Re: ORA-01552 problem [message #210623 is a reply to message #210618] Thu, 21 December 2006 09:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

go through below link
http://forums.oracle.com/forums/thread.jspa?messageID=982829&#982829


hope this helps
Taj
icon9.gif  Re: ORA-01552 problem [message #210638 is a reply to message #210623] Thu, 21 December 2006 11:14 Go to previous messageGo to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

thx i'm using it.

the problem is i'm getting more errors. Sad

plz can anyone help, it's urgent.
thx in advance.
Re: ORA-01552 problem [message #210762 is a reply to message #210638] Fri, 22 December 2006 04:02 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,


1> alter system set undo_management=auto scope=spfile
2> Create another undo tablespace & set it
ALTER SYSTEM SET UNDO_TABLESPACE = new undo tablesapce name


Re: ORA-01552 problem [message #210785 is a reply to message #210762] Fri, 22 December 2006 06:16 Go to previous messageGo to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

hiiii
thx a lot it's done.
Really thx.

thx 4 everyone helped me.
Re: ORA-01552 problem [message #212007 is a reply to message #210785] Wed, 03 January 2007 08:12 Go to previous messageGo to next message
OracleDeveloper
Messages: 5
Registered: July 2006
Junior Member
Hi,

I am also facing something similar to this. Can you please let me know the solution which solved the problem for you?

Thanks in advance,
OracleDeveloper.
Re: ORA-01552 problem [message #212555 is a reply to message #212007] Fri, 05 January 2007 16:39 Go to previous message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

Hi
sorry 4 being late,
see this link, it may be helpful:
http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=456786

plz tell me if the problem still exists.
Best wishes
Previous Topic: [newbie] 10g: add new user: could not log in
Next Topic: Memory Requirement - New Database
Goto Forum:
  


Current Time: Wed Dec 07 10:34:16 CST 2016

Total time taken to generate the page: 0.12637 seconds