My Oracle Support Banner

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

Last updated on NOVEMBER 20, 2017

Applies to:

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


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.


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

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