ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [62]

david

Release 11.2.0.1.0 - 64bit Production
os：redhat5.3 64bit

1.导出语句
Expdp “/******** as sysdba” directory=tmp dumpfile=xxxx.dmp logfile=xxxx.log schema=xxx cluster=N compression=all content=data_only
2.导入语句
impdp system/cmst03 directory=dpdir dumpfile=cms.dmp logfile=imp_cms.log content=data_only schemas=cms parallel=2 transform=oid:n
3.报错信息
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_08" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_08":  system/******** directory=dpdir dumpfile=cms.dmp logfile=imp_cms.log schemas=cms parallel=2
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [62]
TABLE_DATA:"CMS"."CUS_RATINGS_BK"
ORA-31603: object "CUS_RATINGS_BK" of type TABLE not found in schema "CMS"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8170

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x1d37074f0     19028  package body SYS.KUPW$WORKER
0x1d37074f0      8191  package body SYS.KUPW$WORKER
0x1d37074f0     18608  package body SYS.KUPW$WORKER
0x1d37074f0      4104  package body SYS.KUPW$WORKER
0x1d37074f0      8874  package body SYS.KUPW$WORKER
0x1d37074f0      1651  package body SYS.KUPW$WORKER
0x1c7ae5c28         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [62]
TABLE_DATA:"CMS"."CUS_RATINGS_BK"
ORA-31603: object "CUS_RATINGS_BK" of type TABLE not found in schema "CMS"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8170

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x1d37074f0     19028  package body SYS.KUPW$WORKER
0x1d37074f0      8191  package body SYS.KUPW$WORKER
0x1d37074f0     18608  package body SYS.KUPW$WORKER
0x1d37074f0      4104  package body SYS.KUPW$WORKER
0x1d37074f0      8874  package body SYS.KUPW$WORKER
0x1d37074f0      1651  package body SYS.KUPW$WORKER
0x1c7ae5c28         2  anonymous block

Job "SYSTEM"."SYS_IMPORT_SCHEMA_08" stopped due to fatal error at 08:43:56

谢谢！

Maclean Liu(刘相兵

FYI

这是BUG

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2
Information in this document applies to any platform.
Symptoms

From import log file:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [59]
TABLE_DATA:"SDP_DATA_HIST_V112"."NGIN_LDP_HIST_CTL_PRV_RESERVES":"P83"
ORA-31603: object "NGIN_LDP_HIST_CTL_PRV_RESERVES" of type TABLE not found in schema "SDP_DATA_HIST_V112"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8364
Cause

The CONTENT=DATA_ONLY option is used with DataPump import but the table does not exist in the destination database.
Solution

1. Pre-create table in destination database.

Or:

2. Apply patch 9668982 if available for your platform and RDBMS version.

Or:

3. Upgrade onto 11.2.0.3.

david

嗯，谢谢刘大