Error In Data Pull Worker ORA-01652: unable to extend temp segment by 128 in tablespace <name> (Doc ID 1482017.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

When running Data Collections one of the Data Pull Workers completes in error with the following message:

MSCPDPW module: Planning Data Pull Worker

MSC_CL_GMP_UTILITY - Extract_items : l_in_str_org = IN (108,202,205,314,481,544,1141)
MSC_CL_GMP_UTILITY - stmt_no = 10 RSRC_EXTRACT
MSC_CL_GMP_UTILITY - msc_st_department_resources Insert statement INSERT INTO msc_st_department_resources ( ... SQL statement details ... )
MSC_CL_GMP_UTILITY - msc_st_resource_groups Insert statement INSERT INTO msc_st_resource_groups ( ... SQL statement details ... )
MSC_CL_GMP_UTILITY - Error in department/Res Group Insert: 1
MSC_CL_GMP_UTILITY - stmt_no: 20--ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
02-JUL 06:30:01 : Error in Routine MSC_CL_GMP_UTILITY.RSRC_EXTRACT.
02-JUL 06:30:01 : User-Defined Exception
02-JUL 06:30:01 : User-Defined Exception
02-JUL 06:30:01 : Error_Stack...
02-JUL 06:30:01 : ORA-06510: PL/SQL: unhandled user-defined exception

02-JUL 06:30:01 : Error_Backtrace...
02-JUL 06:30:01 : ORA-06512: at "APPS.MSC_CL_PULL", line 6598
ORA-06512: at "APPS.MSC_CL_PULL", line 1692

Cause

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