Oracle DB Error ORA-01562 failed to extend rollback segment number string

The following is the cause of this error:

Failure occurred when trying to extend rollback segment.

Action you can take to resolve this issue: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_ID=string (where string is the segment number from the message) to determine the rollback segment name. Then use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline.

Tags: Database, Education, Software

Related