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:
Root Cause: Oracle issue that prevents the extension of additional storage necessary for the Automation Engine to function correclty.
OS Version: N/A
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: