EP_LOAD_ITEMS : ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

(Doc ID 803052.1)

Last updated on OCTOBER 07, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Apr-2016***

Symptoms

While running EBS full download after completion of shipment and booking history collection, its getting failed at Load item steps the following error occurs:

ERROR
"ERR_DATE PROC_NAME ERR_MSG
 EP_LOAD_ITEMS "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Error in PROCEDURE EP_LOAD_ITEMS line 141

dynamic_ddl( 'BEGIN Ep_Load_Tmp; END;')

Note that this error could also occur during the EP_LOAD_LOCATION procedure




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