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