Database job fails with ORA-01652 message

Products

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

Issue/Introduction

Any database jobs running are failing with the error message below:

 

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Cause

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.

Resolution

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.