Expdp Fails With ORA-1422 Error (Doc ID 1633676.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

In the datapump export log, errors like below are shown:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"SYSTEM"."SQLPLUS_PRODUCT_PROFILE"]
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.05.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 913
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6377
----- PL/SQL Call Stack -----
object line object
handle number name
27E71E7C 15370 package body SYS.KUPW$WORKER
27E71E7C 6436 package body SYS.KUPW$WORKER
27E71E7C 2454 package body SYS.KUPW$WORKER
27E71E7C 7036 package body SYS.KUPW$WORKER
27E71E7C 1340 package body SYS.KUPW$WORKER
27ECC584 2 anonymous block
Job "EXPORT"."SYS_EXPORT_FULL_11" stopped due to fatal error at 07:43:04

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