Loading PRICE.ISC_LOAD_INELIGIBLE_DATES Results In Error "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" (Doc ID 1505014.1)

Last updated on JANUARY 06, 2016

Applies to:

Oracle Retail Markdown Optimization - Version 13.2.4 and later
Information in this document applies to any platform.
*** Checked for relevance on 05-JUN-2014 ***

Symptoms

In Oracle Retail Markdown Optimization (MDO) weekly processing, the ineligible dates load fails with an Oracle error "unable to extend TEMP space".  The database size is 200 GB and the current TEMP table space size is 90 GB.  Only the load process is running and it is using up 90 GB of temp space yet it fails.

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