My Oracle Support Banner

Data Pump Export Of One Schema Crashes With Error ORA-39125 And ORA-04021 (Doc ID 452289.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.5 and later
Information in this document applies to any platform.

Symptoms

Data Pump export (expdp) fails with the following errors:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [OBJECT_GRANT:"VATO"]
ORA-04021: timeout occurred while waiting to lock object SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$),XMLFORMAT.createFormat2('CLUSTER_T', '7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'CLUSTER',KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_CLUSTER_VIEW KU$ WHERE NOT (BITAND (KU$.SCHEMA_OBJ.FLAGS,16)=16) AND KU$.SCHEMA_OBJ.OWNER_NAME IN ('COMMON') AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='CLUSTER' AND A.NAME=KU$.SCHEMA_OBJ.NAME AND A.SCHEMA=KU$.SCHEMA_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.SCHEMA_OBJ.OWNER_NAME)
----- PL/SQL Call Stack -----
object line object
handle number name
0x919f1460 13613 package body SYS.KUPW$WORKER
0x919f1460 5888 package body SYS.KUPW$WORKER
0x919f1460 2077 package body SYS.KUPW$WORKER
0x919f1460 6403 package body SYS.KUPW$WORKER
0x919f1460 1251 package body SYS.KUPW$WORKER
0x93bfb188 2 anonymous block
Job "SYS"."SYS_EXPORT_SCHEMA_03" stopped due to fatal error at 09:35

 

Cause

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
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.