ITPub博客

首页 > 数据库 > Oracle > impdp 只导入数据 ORA-39126 ORA-31603 ORA-06512

impdp 只导入数据 ORA-39126 ORA-31603 ORA-06512

原创 Oracle 作者:like052629 时间:2015-02-09 14:36:37 0 删除 编辑
[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博客 ” ,链接:https://blog.itpub.net/28258625/viewspace-1431237/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-11-18

  • 博文量
    120
  • 访问量
    551552