Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Tue Jan 24 10:31:28 2017 elapsed 0 00:00:11 Now let us try with SKIP_CONSTRAINT_ERRORS option: impdpdumpfile=unique.dmpdirectory=EXPDIR table_exists_action=APPEND data_options=SKIP_CONSTRAINT_ERRORS impdp dumpfile=unique.dmp ...
导入后再删除重复数据再重建索引,或者把表导入为另一个表名,然后再进行关联导入.Oracle 11g开始impdp加了一个data_ooptions参数,参数目前的选项只有skip_constraint_errors,用于在导入时忽略非延迟约束继续执行.