ORA-01552 [message #75861] |
Mon, 01 October 2001 06:13 |
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 |
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 #76093 is a reply to message #75861] |
Mon, 07 June 2004 01:37 |
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
|
|
|