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 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.


Symptoms

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.

Changes

Migrate to RAC configuration.
Use Default Temporary Tablespace feature.

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