Home » Server Options » Text & interMedia » ORA-01552
ORA-01552 [message #75861] Mon, 01 October 2001 06:13 Go to next message
boyron
Messages: 1
Registered: October 2001
Junior Member
cannot use system rollback segment for non-system tablespace...
I tried to create records in a user table and I got this message.
what does it mean ?
How can I resolve it ?

----------------------------------------------------------------------
Re: ORA-01552 [message #75898 is a reply to message #75861] Mon, 07 January 2002 22:27 Go to previous messageGo to next message
Nitin Jain
Messages: 7
Registered: October 2001
Junior Member
-- Create rollback segments.
CREATE ROLLBACK SEGMENT rb1 STORAGE(INITIAL 250K NEXT 250K)
tablespace
;
CREATE ROLLBACK SEGMENT rb2 STORAGE(INITIAL 250K NEXT 250K)
tablespace
;
CREATE ROLLBACK SEGMENT rb3 STORAGE(INITIAL 250K NEXT 250K)
tablespace
;

-- Bring new rollback segments online and ALTER the temporary system one
ALTER ROLLBACK SEGMENT rb1 ONLINE;
ALTER ROLLBACK SEGMENT rb2 ONLINE;
ALTER ROLLBACK SEGMENT rb3 ONLINE;
ALTER ROLLBACK SEGMENT rb4 ONLINE;

Also be sure that initSID.ora file has entry 'rollback_segments = (RB1, RB2, RB3)'. If not restart the instance after odification in initSID.ora file.

Nitin
Re: ORA-01552 [message #76088 is a reply to message #75861] Wed, 21 April 2004 17:56 Go to previous messageGo to next message
alvaro
Messages: 4
Registered: March 2003
Junior Member
your database is open with READ ONLY?
Re: ORA-01552 [message #76093 is a reply to message #75861] Mon, 07 June 2004 01:37 Go to previous message
Momodu Ja'afar I.
Messages: 1
Registered: June 2004
Junior Member
You can do either of the following,

Shutdown the database then uncomment the line (#rollback_segments = ( RBS0, RBS1, RBS2, ....) in the pfile. Startup the instance.

OR

from sqlplus,
select segment_name,status from dba_rollback_segs;

For any segment with offline status, issue the command below:

alter rollback segment <segment_name> online;

All the best,
Ja’afar
Previous Topic: import txt
Next Topic: Configuration in listener.ora
Goto Forum:
  


Current Time: Thu Mar 28 15:34:16 CDT 2024