Expdp Error Ora-39126 on ORACLE Applications (Doc ID 1328393.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Feb-2016***

Symptoms

Trying to use DataPump export (expdp) for exporting a recently-created 11.1.0.7.0 database used for Oracle Applications, errors like the following are raised:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_STATISTICS]
ORA-01801: date format is too long for internal buffer
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 7839
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x938a7910     18237  package body SYS.KUPW$WORKER
0x938a7910      7866  package body SYS.KUPW$WORKER
0x938a7910      2744  package body SYS.KUPW$WORKER
0x938a7910      8504  package body SYS.KUPW$WORKER
0x8f643ef8         1  anonymous block
0x93926fa0      1575  package body SYS.DBMS_SQL
0x938a7910      8342  package body SYS.KUPW$WORKER
0x938a7910      1545  package body SYS.KUPW$WORKER
0x91b38790         2  anonymous block

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