Database job fails with ORA-01652 message
search cancel

Database job fails with ORA-01652 message


Article ID: 88311


Updated On:


CA Automic Applications Manager (AM) Data Loss Prevention Data Loss Prevention Oracle Standard Edition 2


Any database jobs running are failing with the error message below:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP


There are two causes for this:
1. DB server is short on storage and so the TEMP tablespace can't extend to the size it has been allocated.
2. The job is requiring more TEMP space than has been allocated. 
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 space available or add space to the TEMP tablespace of the Oracle database. The DBA will need to determine if the need is to increase storage size or allocated space for the tablespace.