My Oracle Support Banner

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 AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.