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是存在的，如果表结构不存在，则报以上错误。
解决方式：
创建相应结构即可。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28258625/viewspace-1431237/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28258625/viewspace-1431237/