EXPDP = ORA-39126 ORA-1401 on a Sequence

(Doc ID 2407669.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Data Pump Export (expdp) using this syntax:

"system/********@<alias>" parallel=4 CLUSTER=N LOGTIME=ALL COMPRESSION=ALL SCHEMAS=TEST directory=DATA_PUMP_DIR1 dumpfile=expdp_%U.dmp logfile=expdp.log EXCLUDE=STATISTICS

 
fails with the following errors:

...
30-APR-18 13:57:39.688: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [SEQUENCE:"TEST"."ISEQ$$_110156"]
ORA-01401: inserted value too large for column
30-APR-18 13:57:39.688: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
30-APR-18 13:57:39.688: ----- PL/SQL Call Stack -----
object line object
handle number name
0xe5653bb0 27116 package body SYS.KUPW$WORKER
0xe5653bb0 11286 package body SYS.KUPW$WORKER
0xe5653bb0 13515 package body SYS.KUPW$WORKER
0xe5653bb0 3173 package body SYS.KUPW$WORKER
0xe5653bb0 12035 package body SYS.KUPW$WORKER
0xe5653bb0 2081 package body SYS.KUPW$WORKER
0x1fb376548 2 anonymous block
30-APR-18 13:57:39.688: KUPF$FILE.WRITE_LOB
30-APR-18 13:57:39.688: KUPF$FILE.WRITE_LOB
30-APR-18 13:57:39.688: MD FilePieces Count: 1
30-APR-18 13:57:39.688: FORALL
30-APR-18 13:57:39.688: FORALL
30-APR-18 13:57:39.688: DBMS_LOB.TRIM
30-APR-18 13:57:39.688: DBMS_LOB.TRIM
30-APR-18 13:57:39.688: DBMS_METADATA.FETCH_XML_CLOB
30-APR-18 13:57:39.688: DBMS_METADATA.FETCH_XML_CLOB
30-APR-18 13:57:39.688: In procedure DETERMINE_FATAL_ERROR with ORA-01401: inserted value too large for column
...
30-APR-18 13:57:40.577: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [SEQUENCE:"TEST"."ISEQ$$_110156"]
ORA-01401: inserted value too large for column
30-APR-18 13:57:40.577: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
30-APR-18 13:57:40.577: ----- PL/SQL Call Stack -----
object line object
handle number name
0xe5653bb0 27116 package body SYS.KUPW$WORKER
0xe5653bb0 11286 package body SYS.KUPW$WORKER
0xe5653bb0 13515 package body SYS.KUPW$WORKER
0xe5653bb0 3173 package body SYS.KUPW$WORKER
0xe5653bb0 12035 package body SYS.KUPW$WORKER
0xe5653bb0 2081 package body SYS.KUPW$WORKER
0x1fb376548 2 anonymous block
30-APR-18 13:57:40.577: KUPF$FILE.WRITE_LOB
30-APR-18 13:57:40.577: KUPF$FILE.WRITE_LOB
30-APR-18 13:57:40.577: MD FilePieces Count: 1
30-APR-18 13:57:40.577: FORALL
30-APR-18 13:57:40.577: FORALL
30-APR-18 13:57:40.577: DBMS_LOB.TRIM
30-APR-18 13:57:40.577: DBMS_LOB.TRIM
30-APR-18 13:57:40.577: DBMS_METADATA.FETCH_XML_CLOB
30-APR-18 13:57:40.577: DBMS_METADATA.FETCH_XML_CLOB
30-APR-18 13:57:40.577: In procedure DETERMINE_FATAL_ERROR with ORA-01401: inserted value too large for column
30-APR-18 13:57:40.582: Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Mon Apr 30 13:57:40 2018 elapsed 0 00:01:02

 
If the schema is excluded from the expdp, expdp works.

Changes

 

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