ORA-1562 and ORA-1650 Unable to Extend Rollback Segment (Doc ID 1066542.6)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Oracle Solaris on SPARC (32-bit)
***Checked for relevance on 13-Sep-2016***

Symptoms

 You are working with the database that is using Rollback Segments (ie not using automatic undo) and you encounter ora-1562.

Error:    ORA 01562
Text:    "failed to extend rollback segment number %s"
------------------------------------------------------------------------
Cause:     Failure occurred when trying to extend rollback segment
Action:     This is normally followed by another error message that caused the failure.
                You may take the rollback segment offline to perform maintenance. 
                Use the alter rollback segment offline command to take the rollback segment offline.

The 0RA-1562 is often followed by another error which indicates the cause of the failure.

For example, ORA-1650.

Error:      ORA 1650
Text:       unable to extend rollback segment <name> by <num> in tablespace <name>
-------------------------------------------------------------------------------
Cause:      Failed to allocate extent for the rollback segment in tablespace.
Action:     Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms