[oracle@test ~]$ impdp system/password tables=sh.sales content=data_only table_exists_action=truncate network_link=system_link_orcl
Import: Release 11.2.0.4.0 - Production on X
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
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** tables=sh.sales content=data_only table_exists_action=truncate network_link=system_link_orcl
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 15.87 MB
. . imported "SH"."SALES":"SALES_Q4_2001" 0 rows
. . imported "SH"."SALES":"SALES_Q1_1999" 0 rows
. . imported "SH"."SALES":"SALES_Q3_2001" 0 rows
. . imported "SH"."SALES":"SALES_Q1_2000" 0 rows
. . imported "SH"."SALES":"SALES_Q1_2001" 0 rows
. . imported "SH"."SALES":"SALES_Q2_2001" 0 rows
. . imported "SH"."SALES":"SALES_Q3_1999" 0 rows
. . imported "SH"."SALES":"SALES_Q4_1999" 0 rows
. . imported "SH"."SALES":"SALES_Q2_2000" 0 rows
. . imported "SH"."SALES":"SALES_Q3_2000" 0 rows
. . imported "SH"."SALES":"SALES_Q4_1998" 0 rows
. . imported "SH"."SALES":"SALES_Q4_2000" 0 rows
. . imported "SH"."SALES":"SALES_Q2_1999" 0 rows
. . imported "SH"."SALES":"SALES_Q1_1998" 0 rows
. . imported "SH"."SALES":"SALES_Q3_1998" 0 rows
. . imported "SH"."SALES":"SALES_Q2_1998" 0 rows
. . imported "SH"."SALES":"SALES_1995" 0 rows
. . imported "SH"."SALES":"SALES_1996" 0 rows
. . imported "SH"."SALES":"SALES_H1_1997" 0 rows
. . imported "SH"."SALES":"SALES_H2_1997" 0 rows
. . imported "SH"."SALES":"SALES_Q1_2002" 0 rows
. . imported "SH"."SALES":"SALES_Q1_2003" 0 rows
. . imported "SH"."SALES":"SALES_Q2_2002" 0 rows
. . imported "SH"."SALES":"SALES_Q2_2003" 0 rows
. . imported "SH"."SALES":"SALES_Q3_2002" 0 rows
. . imported "SH"."SALES":"SALES_Q3_2003" 0 rows
. . imported "SH"."SALES":"SALES_Q4_2002" 0 rows
. . imported "SH"."SALES":"SALES_Q4_2003" 0 rows
Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at X elapsed 0 00:00:09There's no error, but nothing is imported. Let's try DUMPFILE. This time, it worked.
[oracle@test ~]$ impdp system/password tables=sh.sales content=data_only table_exists_action=truncate dumpfile=20161124_full_exp.dmp
Import: Release 11.2.0.4.0 - Production on X
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 "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** tables=sh.sales content=data_only table_exists_action=truncate dumpfile=20161124_full_exp.dmp
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
. . imported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . imported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . imported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . imported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . imported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . imported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . imported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . imported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows
. . imported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . imported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . imported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . imported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows
. . imported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . imported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows
. . imported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at X elapsed 0 00:00:10Does anybody know what happen?