ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT
源：12.2.0.1目标：11.2.0.4
[oracle@ dmp]$ expdp \'/ as sysdba\' directory=dmp schemas=xczhh version=11.2 dumpfile=xczhh-`date "+%Y%m%d_%H%M%S"`.dmp logfile=xczhh-`date "+%Y%m%d_%H%M%S"`.log EXCLUDE=TABLE:\"IN \(\'EE_SCENE_ORDER_LOG\'\)\" exclude=TABLE:\"LIKE\'%20%\'\" exclude=TABLE:\"LIKE\'EE_SCENE_ORDER_AUTO_%\'\" exclude=statistics
Export: Release 12.2.0.1.0 - Production on Fri May 28 13:30:04 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Warning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers.
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" directory=dmp schemas=xczhh version=11.2 dumpfile=xczhh-20210528_133004.dmp logfile=xczhh-20210528_133004.log EXCLUDE=TABLE:"IN ('EE_SCENE_ORDER_LOG')" exclude=TABLE:"LIKE'%20%'" exclude=TABLE:"LIKE'EE_SCENE_ORDER_AUTO_%'" exclude=statistics
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39373: cannot export TABLE_DATA:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_210303ZXSC" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE_DATA:"XCZHH"."TSM_TASK_RES_ANSWERDETAILR_BAK191012" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE_DATA:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_BAK191230" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39373: cannot export PACKAGE_BODY:"XCZHH"."PKG_EE_SCENE_ORDER_ZB_MONTHS_HISTORY" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
...............
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"SYS"."SYS_EXPORT_SCHEMA_01"]
INSERT INTO "SYS"."KU$_DATAPUMP_MASTER_11_2" (abort_step,ancestor_process_order,base_object_name,base_object_schema,base_object_type,base_process_order,block_size,cluster_ok,completed_bytes,completed_rows,completion_time,control_queue,creation_level,cumulative_time,data_buffer_size,data_io,dataobj_num,db_version,degree,domain_process_order,dump_allocation,dump_fileid,dump_length,dump_orig_length,dump_position,duplicate,elapsed_time,error_count,extend_size,file_max_size,file_name,file_type,flags,grantor,granules,guid,in_progress,instance,instance_id,is_default,job_mode,job_version,last_file,last_update,load_method,metadata_buffer_size,metadata_io,name,object_int_oid,object_long_name,object_name,object_number,object_path_seqno,object_row,object_schema,object_tablespace,object_type,object_type_path,old_value,operation,original_object_name,original_object_schema,packet_number,parallelization,parent_process_order,partition_name,phase,platform,process_name,process_order,processing_state,processing_status,property,queue_tabnum,remote_link,scn,seed,service_name,size_estimate,start_time,state,status_queue,subpartition_name,timezone,total_bytes,trigflag,unload_method,user_directory,user_file_name,user_name,value_n,value_t,version,work_item,xml_clob)SELECT abort_step,ancestor_process_order,base_object_name,base_object_schema,base_object_type,base_process_order,block_size,cluster_ok,completed_bytes,completed_rows,completion_time,control_queue,creation_level,cumulative_time,data_buffer_size,data_io,dataobj_num,db_version,degree,domain_process_order,dump_allocation,dump_fileid,dump_length,dump_orig_length,dump_position,duplicate,elapsed_time,error_count,extend_size,file_max_size,file_name,file_type,flags,grantor,granules,guid,in_progress,instance,instance_i
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12098
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 15497
----- PL/SQL Call Stack -----
object line object
handle number name
0x113e33d78 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x113e33d78 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x113e33d78 15508 package body SYS.KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT
0x113e33d78 4128 package body SYS.KUPW$WORKER.UNLOAD_DATA
0x113e33d78 13094 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x113e33d78 2311 package body SYS.KUPW$WORKER.MAIN
0xaef8adc0 2 anonymous block
0 rows updated with domain process order for INDEXES
0 secondary tables updated
0 rows updated for secondary table data with domain process order
0 rows updated for secondary tables with ancestor process order
0 rows updated for template base object information
In procedure UPDATE_MT_DEPENDENT_OBJECTS
ROWCOUNT marked bad: 0
ROWCOUNT removed from bad objects: 0
Using temporary master table "SYS"."KU$_DATAPUMP_MASTER_11_2"
In procedure DETERMINE_FATAL_ERROR with ORA-12899: value too large for column "SYS"."KU$_DATAPUMP_MASTER_11_2"."BASE_OBJECT_NAME" (actual: 32, maximum: 30)
导入报错：
[oracle@ dmp]$ impdp \'/ as sysdba\' directory=dmp schemas=xczhh dumpfile=xczhh-20210528_133004.dmp logfile=xczhh-`date "+%Y%m%d_%H%M%S"`.log
Import: Release 11.2.0.4.0 - Production on Fri May 28 13:23:28 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
处理：
考虑改用exp/imp方式
exp xxx/xxx@xczhh183 file=xczhh20210508-n.dmp log=20210528-n.log owner=xczhh direct=y buffer=65535000 rows=n报错
. . exporting table EE_SCENE_ORDER1130
. . exporting table EE_SCENE_ORDER20200102
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
考虑尝试：只导元数据正常
expdp \'/ as sysdba\' directory=dmp version=11.2 schemas=xczhh content=metadata_only exclude=statistics dumpfile=xczhh_meta.dmp logfile=xczhh_meta.log
单表也可成功：
expdp xczhh/xxx tables=T_USER dumpfile=T_USER.dmp logfile=T_USER.log directory=dmp version=11.2 exclude=statistics
[oracle@GXWQdatanode03 dmp]$ expdp \'/ as sysdba\' directory=dmp version=11.2 schemas=xczhh content=metadata_only exclude=statistics dumpfile=xczhh_meta.dmp logfile=xczhh_meta.log
Export: Release 12.2.0.1.0 - Production on Fri May 28 15:05:32 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Warning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers.
Starting "SYS"."SYS_EXPORT_SCHEMA_03": "/******** AS SYSDBA" directory=dmp version=11.2 schemas=xczhh content=metadata_only exclude=statistics dumpfile=xczhh_meta.dmp logfile=xczhh_meta.log
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39373: cannot export PACKAGE_BODY:"XCZHH"."PKG_EE_SCENE_ORDER_ZB_MONTHS_HISTORY" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200715_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_PLAN_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200221_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_PLAN_20200216_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200216_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200226_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200507_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TASK_RESOURCES_BEFORE_DELETE_20191211" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."EE_SCENE_ORDER_20200318_12_1_E" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200415_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200222_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_PLAN_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_PLANS_RESOURCES_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200226_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_PLANS_RESOURCES_20200216_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_PLANS_RESOURCES_20200218_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."T_JT_DATA_DETAIL_ZB_BAKZX201214" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."EE_SCENE_ORDER_20201027ˢAL_OPER" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200715_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200527_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200218_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200415_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."EE_SCENE_ORDER_20201001_20201027" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200609_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."EE_SCENE_ORDER_2020011412" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200609_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200218_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200222_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_PLANS_RESOURCES_20200226_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200328_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_210303ZXSC" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200216_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200609_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RESOURCES_20200221_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_PLAN_20200226_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAILR_BAK191012" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200507_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_PLANS_RESOURCES_20200408_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200507_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200527_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TASK_RESOURCES_BEFORE_DELETE_20191209" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200527_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200508_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200715_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWER_20200415_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_BAK191230" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200508_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_TASK_RES_ANSWERDETAIL_20200508_LY" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_TASK_20200415_LXF" to version 11.2 due to long identifiers
ORA-39373: cannot export TABLE:"XCZHH"."TSM_INSPECTION_PLAN_20200218_LXF" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
ORA-39373: cannot export PACKAGE:"XCZHH"."PKG_EE_SCENE_ORDER_ZB_MONTHS_HISTORY" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
ORA-39373: cannot export PROCEDURE:"XCZHH"."EE_SCENE_ORDER_UPDATE_IS_OVERTIME" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
ORA-39373: cannot export ALTER_PACKAGE_SPEC:"XCZHH"."PKG_EE_SCENE_ORDER_ZB_MONTHS_HISTORY" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39373: cannot export ALTER_PROCEDURE:"XCZHH"."EE_SCENE_ORDER_UPDATE_IS_OVERTIME" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39373: cannot export INDEX:"XCZHH"."T_JT_ORDERDATAINFO_ZB_PROFESSION" to version 11.2 due to long identifiers
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/JOB
dateMaster table "SYS"."SYS_EXPORT_SCHEMA_03" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_03 is:
/oracle/dmp/xczhh_meta.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_03" completed with 63 error(s) at Fri May 28 15:09:06 2021 elapsed 0 00:03:34
[oracle@GXWQdatanode03 dmp]$ chmod 777 /oracle/dmp/xczhh_meta.dmp结合导表：
exp xczhh/xxx@xczhh183 file=xczhh20210508.dmp log=20210528.log owner=xczhh direct=y buffer=65535000 tables=FEEDBACK,EM_ORDER,TSM_DATA_RELATION,EE_CJMX,EV_ORDER,xxx
还是有失败
. . exporting table TPR_FUNCTIONS 75 rows exported
. . exporting table TPR_ROLES 4 rows exported
. . exporting table T_TEAM_NOSHOW 10 rows exported
. . exporting table T_JT_ORDERDATA_0310 3555 rows exported
Table SYS_EXPORT_SCHEMA_01 will be exported in conventional path.
. . exporting table SYS_EXPORT_SCHEMA_01 6323 rows exported
. . exporting table EE_SCENE_ORDER_STATIC 1539608 rows exported
EXP-00011: XCZHH.EE_SCENE_ORDER_COPY1 does not exist
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
导入:
imp xxx/xxx file=xczhh20210508.dmp log=20210528-imp.log buffer=65535000 fromuser=xczhh touser=xczhh
impdp \'/ as sysdba\' directory=dmp full=y dumpfile=xczhh_meta.dmp logfile=xczhh_meta_imp.log
原因:
ORA-12899 During Expdp With VERSION parameter In 12.1.0.2 (Doc ID 2051535.1)
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
The issue is addressed in: Bug 22119791 - ORA-12899 WITH EXPDP WHEN SETTING NLS_LANG=GERMAN, fixed in 12.2.
The issue is caused when the definition of the DataPump master table like "SYS"."KU$_DATAPUMP_MASTER_10_1" or "SYS"."KU$_DATAPUMP_MASTER_11_2" does not match with the actual NLS Length Semantics.
This can happen when a multi-byte language is being used.
The error is generated because when we set NLS_LANG to a multi-byte language (for example: GERMAN) then column order is: -
COL_NAME
--------------------------------------------------------------------------------
phase
platform
processing_state
processing_status
process_name
process_order
property
queue_tabnum
remote_link
scn
seed
for the master table.
And for the global temp table used in FIXUP_MASTER_TABLE procedure, the columns order is:
COL_NAME
--------------------------------------------------------------------------------
phase
platform
process_name
process_order
processing_state
processing_status
property
queue_tabnum
remote_link
scn
seed
Due to the mismatch of column order the worker process generates ORA-12899.
SOLUTION
To solve the issue, use any of below alternatives:
- Apply interim patch 22119791 and and run the post-install step:
1. Navigate to the <ORACLE_HOME>/OPatch directory:
$ cd <ORACLE_HOME>/OPatch
2. Install the SQL portion of the patch by running the following command:
$ datapatchNote: For a RAC environment, perform these steps on only one node.
To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to:
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?
If no patch exists for your version, please contact Oracle Support for a backport request.
- OR -
- Upgrade to 12.2 when available.
- OR -
- When compatible is set to 10.2 for a 12.1 database, start the export with version=12.1 to avoid the error.