impdp 只匯入資料 ORA-39126 ORA-31603 ORA-06512

[oracle@test dump_dir]$ impdp system/system directory=dump_dir dumpfile=20150209.dmp CONTENT=DATA_ONLY DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS


Import: Release 11.2.0.1.0 - Production on ? 2 14:27:16 2015


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


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
YSTEM"."SYS_IMPORT_SCHEMA_22" 
 "SYSTEM"."SYS_IMPORT_SCHEMA_22":  system/********@test directory=dump_dir dumpfile=TEST_20150209.dmp SCHEMAS=TEST CONTENT=DATA_ONLY DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS 
 SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: UPW$WORKER.UPATE_TD_ROW_IMP [62] orker 


                                                   TABLE_DATA:"TEST"."WF_CUST"
ORA-31603:  "WF_CUST"  TABLE, TEST" 




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


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


ORA-39126: UPW$WORKER.UPATE_TD_ROW_IMP [62] orker 


                                                   TABLE_DATA:"TEST"."WF_CUST"
ORA-31603:  "WF_CUST"  TABLE, TEST" 




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


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


 "SYSTEM"."SYS_IMPORT_SCHEMA_22"  14:27:24 ?? 

原因：由於content=data_only，匯入時，必須確定meta_data是存在的，如果表結構不存在，則報以上錯誤。
解決方式：
建立相應結構即可。