Data Pump Export Terminates With ORA-39126 Errors After Upgrading From 10g To 11.1.0.7 or 11.2.0.1 (Doc ID 979422.1)

Last updated on NOVEMBER 09, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

While attempting to perform a Data Pump export, the following errors were reported:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": /******** AS SYSDBA parfile=expdp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 83 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/RLS_POLICY
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TRIGGER:"..."."..."]
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
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
3907e53d8 18237 package body SYS.KUPW$WORKER
3907e53d8 7866 package body SYS.KUPW$WORKER
3907e53d8 2744 package body SYS.KUPW$WORKER
3907e53d8 8504 package body SYS.KUPW$WORKER
38f045540 1 anonymous block
3958b14a8 1575 package body SYS.DBMS_SQL
3907e53d8 8342 package body SYS.KUPW$WORKER
3907e53d8 1545 package body SYS.KUPW$WORKER
3958dfc50 2 anonymous block

Job "SYS"."SYS_EXPORT_TABLE_01" stopped due to fatal error at ...

Changes

The database was recently upgraded the database from 10g to 11.1.0.7.

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