ORA-39083: Object type REF_CONSTRAINT failed to create with error:

[oracle@localhost aiki]$ impdp aiki/aiki directory=aiki_direc file=db_full_backup2.dmp  tables='T_f' log=impdp.log

Import: Release 11.2.0.2.0 - Production on Tue Feb 7 16:05:43 2012

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=db_full_backup2.dmp" Location: Command Line, Replaced with: "dumpfile=db_full_backup2.dmp"
Legacy Mode Parameter: "log=impdp.log" Location: Command Line, Replaced with: "logfile=impdp.log"
Master table "AIKI"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded
Starting "AIKI"."SYS_IMPORT_TABLE_03":  aiki/******** directory=aiki_direc dumpfile=db_full_backup2.dmp tables=T_f logfile=impdp.log
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "AIKI"."T_F"                                5.406 KB       1 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (AIKI.FK_TT) - parent keys not found
Failing sql is:
ALTER TABLE "AIKI"."T_F" ADD CONSTRAINT "FK_TT" FOREIGN KEY ("V") REFERENCES "AIKI"."TT" ("V") ENABLE

Job "AIKI"."SYS_IMPORT_TABLE_03" completed with 1 error(s) at 16:05:48


cause:

主外键约束,当主键插进去后做了修改,将原来外键在主键的值删了,再导入外键表时

数据导入后,再导入约束(constraints)时就报错,没有加上去;



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值