ORA-01652 errors cause DB Load to fail or AE to become inoperable

Document ID : KB000087453
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ORA-01652: unable to extend temp segment by 128 in tablespace 'XXXX'

The error above Oracle error message occurs in different scenarios, such as:
  • DB Load failing
  • Automation Engine (AE) inoperable
Investigation

This issue occurs because one of the data files which the tablespace consists of has reached its size limit. Basically the Automation Engine's Oracle database has no available storage in its temporary segment, which prevents the Automation Engine server and utilities from running correctly.


 
Environment:
OS Version: N/A
Cause:
Cause type:
Other
Root Cause: Oracle issue that prevents the extension of additional storage necessary for the Automation Engine to function correclty.
Resolution:
This is a database issue already documented by Oracle: https://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423

ORA-01652: unable to extend temp segment by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

You have 2 possibilities that should be performed by an Oracle DBA:
  1. Punctually increase the tablespace's size
OR
  1. Set tablespaces to autoextend=yes in Oracle


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A