RAC databases and ORA-1652: Unable To Extend Temp Segment By %s In Tablespace TEMP

(Doc ID 258941.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.


Scripts may fail due to ORA-1652 "unable to extend temp segment by %s in
tablespace TEMP"
although free space exists in TEMP tablespace in a RAC database configuration.
Also scripts may not fail you may find error messages (ORA-1652)
inside the alert.log of some of the instances.


Migrate to RAC configuration.
Use Default Temporary Tablespace feature.


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