OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01552 problem

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

ORA-01552 problem [message #209968]

Mon, 18 December 2006 15:41

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 ?

Report message to a moderator

Re: ORA-01552 problem [message #209970 is a reply to message #209968]

Mon, 18 December 2006 15:55

Barbara Boehmer
Messages: 9097
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."

Report message to a moderator

Re: ORA-01552 problem [message #210147 is a reply to message #209970]

Tue, 19 December 2006 10:57

assoora28
Messages: 18
Registered: December 2006
Location: Jordan

Junior Member

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

plz plz help.

Report message to a moderator

Re: ORA-01552 problem [message #210220 is a reply to message #210147]

Tue, 19 December 2006 20:57

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.

Report message to a moderator

Re: ORA-01552 problem [message #210406 is a reply to message #209970]

Wed, 20 December 2006 12:19

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

Report message to a moderator

Re: ORA-01552 problem [message #210441 is a reply to message #210406]

Wed, 20 December 2006 18:43

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?

Report message to a moderator

Re: ORA-01552 problem [message #210618 is a reply to message #210441]

Thu, 21 December 2006 09:39

assoora28
Messages: 18
Registered: December 2006
Location: Jordan

Junior Member

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

thx in advance

Report message to a moderator

Re: ORA-01552 problem [message #210623 is a reply to message #210618]

Thu, 21 December 2006 09:56

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

Report message to a moderator

Re: ORA-01552 problem [message #210638 is a reply to message #210623]

Thu, 21 December 2006 11:14

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.

Report message to a moderator

Re: ORA-01552 problem [message #210762 is a reply to message #210638]

Fri, 22 December 2006 04:02

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

Report message to a moderator

Re: ORA-01552 problem [message #210785 is a reply to message #210762]

Fri, 22 December 2006 06:16

assoora28
Messages: 18
Registered: December 2006
Location: Jordan

Junior Member

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

thx 4 everyone helped me.

Report message to a moderator

Re: ORA-01552 problem [message #212007 is a reply to message #210785]

Wed, 03 January 2007 08:12

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.

Report message to a moderator

Re: ORA-01552 problem [message #212555 is a reply to message #212007]

Fri, 05 January 2007 16:39

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

Report message to a moderator

Previous Topic:	[newbie] 10g: add new user: could not log in
Next Topic:	Memory Requirement - New Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:51:56 CDT 2024