Data Pump

Network Link May Not Work When Importing Partitioned Tables

I found I can’t import partitioned table via NETWORK_LINK.
[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:09

There’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:10

Does anybody know what happen?

Leave a Reply

Your email address will not be published. Required fields are marked *