RAC databases and ORA-1652: Unable To Extend Temp Segment By %s In Tablespace TEMP
Last updated on JUNE 22, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 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.
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