Banner job fails with ORA-01652 message

Document ID : KB000088311
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Banner job fails with ORA-01652 message
Resolution:
Detailed Description and Symptoms
 
Any Banner Jobs running are failing with the error message below:
 
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
 
Solution
 
When a new segment is created, Oracle uses temporary extents to initially build it before it converts the extent to a permanent value. If there is not enough tablespace, it results in the Oracle error which in turn causes the job to fail.
 
The DBA needs to increase/add space to the TEMP tablespace of the Oracle database.