[oracle@centos expdp]$ impdp scott/tiger@oraDB11g tables=dept directory=test_dir dumpfile=dept.dmp logfile=expdpdept.log parallel=4 table_exists_action=append Import: Release 11.2.0.4.0 - Production on Thu Aug 6 13:22:41 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SCOTT"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SCOTT"."SYS_IMPORT_TABLE_01": scott/********@oraDB11g tables=dept directory=test_dir dumpfile=dept.dmp logfile=expdpdept.log parallel=4 table_exists_action=append Processing object type TABLE_EXPORT/TABLE/TABLE Table "SCOTT"."DEPT" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "SCOTT"."DEPT" failed to load/unload and is being skipped due to error: ORA-00001: unique constraint (SCOTT.PK_DEPT) violated Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Job "SCOTT"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at Thu Aug 6 13:22:43 2020 elapsed 0 00:00:02
어떤게 문제인지 잘모르겠네요.. scott유저에 DEPTNO가 PK라 안되는건지... table_exists_action=append 옵션주고 나머지 데이터만 추가하려는데 안되네요...