My Oracle Support Banner

DataPump Export Fails With Errors ORA-39125 ORA-31642 ORA-1422 (Doc ID 790988.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 23-Apr-2013***


DataPump export (EXPDP) fails with the following errors:

#> expdp system/passworde schemas=scott content=metadata_only dumpfile=scott.dmp


ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-31642: the following SQL statement fails:
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 907
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6228
----- PL/SQL Call Stack -----
object line object
handle number name
0x239ced9c 14916 package body SYS.KUPW$WORKER
0x239ced9c 6293 package body SYS.KUPW$WORKER
0x239ced9c 2339 package body SYS.KUPW$WORKER
0x239ced9c 6854 package body SYS.KUPW$WORKER
0x239ced9c 1259 package body SYS.KUPW$WORKER
0x308382a8 2 anonymous block


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

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