RAC databases and ORA-1652: Unable To Extend Temp Segment By %s In Tablespace TEMP
(Doc ID 258941.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 10.2.0.1 [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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!