ORA-01652: "Unable to Extend Temp Segment" Exception When Running InjectorPriceEventBatch (Doc ID 1338273.1)

Last updated on JUNE 09, 2016

Applies to:

Oracle Retail Price Management - Version 13.1 to 13.1.3.3 [Release 13.1]
Information in this document applies to any platform.
Checked for relevance on 10-June-2016

Symptoms

In Retail Price Management (RPM) 13.1.x, while processing more than 200 items using the InjectorPriceEventBatch, the following error is thrown:

@0PACKAGE_ERROR@1ORA-01652: unable to extend temp segment by 128 in tablespace TEMP@2RPM_BULK_CC_THREADING_SQL.CHECK_OVERLAP


Steps to Recreate:

1. Insert around 14000 items in RPM_STAGE_PRICE_CHANGE table for regular price change.
2. Execute InjectorPriceEventBatch.
3. Error occurs.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms