My Oracle Support Banner

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

Last updated on JANUARY 18, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Solaris on SPARC (32-bit)


 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.



To view full details, 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 a vibrant support community of peers and Oracle experts.