ORA-12899 During Expdp With VERSION parameter In 12.1.0.2 (Doc ID 2051535.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Running a DataPump Export:

- with version=10.2 in a 12c database
  - or -
- in a 12c database with compatible set to 10.2

fails with:

...
ORA-39126: Uventet uopprettelig arbeiderfeil i KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"SYSTEM"."SYS_EXPORT_FULL_09"]
ORA-12899: verdien er for stor for kolonnen "SYS"."KU$_DATAPUMP_MASTER_10_1"."PROCESSING_STATUS" (faktisk: 2, maksimum: 1)
ORA-06512: ved "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: ved "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
  object line object
  handle number name
0x118de2b90 27116 package body SYS.KUPW$WORKER
0x118de2b90 11286 package body SYS.KUPW$WORKER
0x118de2b90 14133 package body SYS.KUPW$WORKER
0x118de2b90 3560 package body SYS.KUPW$WORKER
0x118de2b90 12049 package body SYS.KUPW$WORKER
0x118de2b90 2081 package body SYS.KUPW$WORKER
0x11ee420a0 2 anonymous block
Updated 1139 td objects with bpo
Updated 0 td objects with option_tag
In procedure FIXUP_MASTER_TABLE_EXPORT Worker code version: 12.1.0.2.0 and compatibility version: 10.2

 

If version=11.2 or compatible=11.2, the expdp error looks like:

...
ORA-39126: Unerwarteter schwerwiegender Fehler für Worker in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"SYSTEM"."SYS_EXPORT_FULL_20"]
ORA-12899: Wert zu groß für Spalte "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS" (aktuell: 2, maximal: 1)

ORA-06512: in "SYS.DBMS_SYS_ERROR", Zeile 95
ORA-06512: in "SYS.KUPW$WORKER", Zeile 11259

----- PL/SQL Call Stack -----
object line object
handle number name
0x6db8f230 27116 package body SYS.KUPW$WORKER
0x6db8f230 11286 package body SYS.KUPW$WORKER
0x6db8f230 14133 package body SYS.KUPW$WORKER
0x6db8f230 3560 package body SYS.KUPW$WORKER
0x6db8f230 12049 package body SYS.KUPW$WORKER
0x6db8f230 2081 package body SYS.KUPW$WORKER
0x693dbfe8 2 anonymous block

...

In procedure FIXUP_MASTER_TABLE_EXPORT Worker code version: 12.1.0.2.0 and compatibility version: 11.2
0 rows updated for template base object information
Using temporary master table "SYS"."KU$_DATAPUMP_MASTER_11_2"
In procedure DETERMINE_FATAL_ERROR with ORA-12899: Wert zu groß für Spalte "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS" (aktuell: 2, maximal: 1)

 

Changes

Note that the numbers in the DataPump master table name depends on the value of the COMPATIBLE parameter:

- for compatible set to 10.2.X.X.X, the DataPump master table name is: KU$_DATAPUMP_MASTER_10_1
- for compatible set to 11.2.X.X.X, the DataPump master table name is: KU$_DATAPUMP_MASTER_11_2 

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