Email: service@parnassusdata.com 7 x 24 online support!
ORA-1545 during DROP ROLLBACK SEGMENT <rbsname>
ORA-1545 may be signalled during a "DROP ROLLBACK SEGMENT" if the rollback segment is currently online. eg: SVRMGR> drop rollback segment rprbs; drop rollback segment rprbs * ORA-01545: rollback segment '' specified not available Actions: 1. Check the status of the rollback segment in DBA_ROLLBACK_SEGS. eg: SELECT segment_id, status FROM dba_rollback_segs WHERE segment_name = ' '; Note the SEGMENT_ID and STATUS for the steps below. 2. If the STATUS is ONLINE then: ALTER ROLLBACK SEGMENT OFFLINE; DROP ROLLBACK SEGMENT ; If this still reports ORA-1545 continue with step 3 below. 3. ORA-1545 may also be signalled if there is a problem reading the rollback segment header information or if the rollback segment contains active or in-doubt transactions. Note the SEGMENT_ID and SEGMENT_NAME and go to "Recovering Rollback Segments"