My Oracle Support Banner

After Applying Patch 23091027 When Large Batch Job Runs Error Occurs: ORA-1652: unable to extend temp segment by 128 in tablespace (Doc ID 2210813.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Utilities Framework - Version 4.2.0.2.0 to 4.3.0.4.0 [Release 4.2 to 4.3]
Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Information in this document applies to any platform.

Symptoms

**Any examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:

MDM - Oracle Utilities Meter Data Management

In Oracle Utilities Application Framework 4.2.0.2 and Meter Data Management 2.1.0.2, large batch jobs like D1-IMD encounter ORA-1652 error. The new error occurs when batch jobs, that process large amounts of records with CLOB transactions (for example, 100,000+ records), are executed.

Error

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

Changes

This began after applying Patch 23091027.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.