This is not a question rather the solution of a problem that occupied me a whole day.
If you have a 12cR1, want to export to a 11gR2 (or any version lower than 12c) and do not use an English-like language, you will encounter this problem.
First, your export works in full 12c (what's inside expdp.txt does not matter):
D:\Oracle\Admin\MIKC\Log>expdp parfile=expdp.txt
Export: Release 12.1.0.2.0 - Production on Mar. Août 1 18:35:33 2017
Copyright (c) 1982, 2016, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "MICHEL"."SYS_EXPORT_TABLE_08": michel/********@orafaq parfile=expdp.txt
Startup took 0 seconds
Estimate in progress using BLOCKS method...
...
Master table "MICHEL"."SYS_EXPORT_TABLE_08" successfully loaded/unloaded
******************************************************************************
Dump file set for MICHEL.SYS_EXPORT_TABLE_08 is:
D:\ORACLE\ADMIN\MIKC\LOG\ORAFAQ.DMP
Job "MICHEL"."SYS_EXPORT_TABLE_08" completed with 1 error(s) at Mar. Août 1 18:35:54 2017 elapsed 0 00:00:10
D:\Oracle\Admin\MIKC\Log>expdp parfile=expdp.txt VERSION=11.2
Export: Release 12.1.0.2.0 - Production on Mar. Ao¹t 1 17:13:04 2017
Copyright (c) 1982, 2016, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "MICHEL"."SYS_EXPORT_TABLE_03": michel/********@orafaq parfile=expdp.txt VERSION=11.2
Startup took 0 seconds
Estimate in progress using BLOCKS method...
...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"MICHEL"."SYS_EXPORT_TABLE_03"]
ORA-12899: value too large for column "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS" (actual: 2, maximum: 1)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
000007FF96D47D30 27116 package body SYS.KUPW$WORKER
000007FF96D47D30 11286 package body SYS.KUPW$WORKER
000007FF96D47D30 14133 package body SYS.KUPW$WORKER
000007FF96D47D30 3560 package body SYS.KUPW$WORKER
000007FF96D47D30 12049 package body SYS.KUPW$WORKER
000007FF96D47D30 2081 package body SYS.KUPW$WORKER
000007FFAC281190 2 anonymous block
In procedure SEND_MSG. Fatal=0
KUPC$QUEUE_INT.SEND
KUPC$QUEUE_INT.SEND
Completed 7 TABLE_EXPORT/TABLE/TABLE_DATA objects in 5 seconds
In procedure UPDATE_TD_BASE_PO_INFO
Updated 7 td objects with bpo
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: value too large for column "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS"
(actual: 2, maximum: 1)
Job "MICHEL"."SYS_EXPORT_TABLE_03" stopped due to fatal error at Mar. Ao¹t 1 17:13:23 2017 elapsed 0 00:00:09
D:\Oracle\Admin\MIKC\Log>expdp parfile=expdp.txt VERSION=11.2.0.4
Export: Release 12.1.0.2.0 - Production on Mar. Ao¹t 1 17:14:32 2017
Copyright (c) 1982, 2016, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "MICHEL"."SYS_EXPORT_TABLE_04": michel/********@orafaq parfile=expdp.txt VERSION=11.2.0.4
...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"MICHEL"."SYS_EXPORT_TABLE_04"]
ORA-12899: value too large for column "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS" (actual: 3, maximum: 1)
...
In procedure FIXUP_MASTER_TABLE_EXPORT Worker code version: 12.1.0.2.0 and compatibility version: 11.2.0.4
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: value too large for column "SYS"."KU$_DATAPUMP_MASTER_11_2"."PROCESSING_STATUS"
(actual: 3, maximum: 1)
Job "MICHEL"."SYS_EXPORT_TABLE_04" stopped due to fatal error at Mar. Ao¹t 1 17:14:51 2017 elapsed 0 00:00:08
Now applying this patch you may encounter another issue.
After applying it using "opatch apply", don't forget to execute "datapatch" from directory ORACLE_HOME/OPatch.
This later may fail with error message catconInit failed, exiting
with the following message in the log or lst file catconInit: database is not open on the default instance
The reason may be one or both of the followings:
* glogin.sql or login.sql contains a "set" command that is incompatible with catcon.pl program called by "datapatch"
* SQLPATH environment variable is set
The solution is:
* rename glogin.sql and login.sql during the execution of "datapatch"
* unset SQLPATH
That's all.
[Updated on: Fri, 06 October 2017 08:28]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
