Banner job fails with ORA-01652 message

Document ID : KB000088311
Last Modified Date : 14/04/2018
Show Technical Document Details
Banner job fails with ORA-01652 message
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
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.