dataPump Export (EXPDP) Fails With Error ORA-1801 In 10g Databases Migrated From Earlier Releases (Doc ID 374600.1)

Last updated on JUNE 25, 2013

Applies to:

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

Symptoms

When trying to export a migrated database from a pre 10g version to 10gR1, the following errors occur:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while
calling DBMS_METADATA.FETCH_XML_CLOB [TABLE:"AESP"."PEM_ORG_AUDIT"]
ORA-01801: date format is too long for internal buffer

----- PL/SQL Call Stack -----
object line object
handle number name
39bf78600 13460 package body SYS.KUPW$WORKER
39bf78600 5810 package body SYS.KUPW$WORKER
39bf78600 2034 package body SYS.KUPW$WORKER
39bf78600 6325 package body SYS.KUPW$WORKER
39bf78600 1208 package body SYS.KUPW$WORKER
39588c780 2 anonymous block

Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 14:47

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