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

最新推荐文章于 2022-06-23 17:00:28 发布

iteye_18365

最新推荐文章于 2022-06-23 17:00:28 发布

阅读量1k

点赞数

文章标签：数据库

本文记录了一次使用Oracle数据库进行数据导入时遇到的主外键约束错误，并详细解释了错误产生的原因及解决方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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)时就报错，没有加上去;