导入后再删除重复数据再重建索引,或者把表导入为另一个表名,然后再进行关联导入.Oracle 11g开始impdp加了一个data_ooptions参数,参数目前的选项只有skip_constraint_errors,用于在导入时忽略非延迟约束继续执行.
解决方法就是使用参数data_options=SKIP_CONSTRAINT_ERRORS。 $ impdp scott/book DIRECTORY=DATA_PUMP_DIR DUMPFILE=t.dp table_exists_action=append tables=t data_options=SKIP_CONSTRAINT_ERRORS Import: Release 11.2.0.4.0 - Production on Fri Apr 21 10:24:48 2017 Copyright (c) 1982, 2011, Oracle ...
Value 2:SKIP_CONSTRAINT_ERRORS This page I wanted to elaborate more on this parameter value SKIP_CONSTRAINT_ERRORS. In normal case the impdp utility will rollback the entire table import in case any constraint error encounters on that particular table. If you use SKIP_CONSTRAINT_ERRORS as the ...
解决方法就是使用参数data_options=SKIP_CONSTRAINT_ERRORS。 $ impdp scott/book DIRECTORY=DATA_PUMP_DIR DUMPFILE=t.dp table_exists_action=append tables=t data_options=SKIP_CONSTRAINT_ERRORS Import: Release 11.2.0.4.0 - Production on Fri Apr 21 10:24:48 2017 Copyright (c) 1982, 2011, Oracle ...