ORA-01652 unable to extend temp segment by Error when running Demantra Ep_Load type procedures such as Ep_Load_Items or Ep_Load_Location or Ep_Load_Sales (Doc ID 857676.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

Client encountered an ORA-01652 when on either Ep_Load_Items or Ep_Load_Location or Ep_Load_Sales even though the Temp tablespace has been set to Unlimited

Example error message:

07-07-2009 13:5 EP_LOAD_ITEMS
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP5
      Error in PROCEDURE EP_LOAD_ITEMS line 125

         dynamic_ddl( 'BEGIN Ep_Load_Tmp; END;')

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