11g expdp 及 impdp 中的参数 network_link - 4 如何使用 network_link

e. 在目标库上开始导出。  
[oravis@szdb06 ~]$ expdp apps/apps  DIRECTORY=dumpdir NETWORK_LINK=touat3 DUMPFILE=test_wq.dmp  tables=APPS.TEST_WQ logfile=test_expdp.log 

Export: Release 11.2.0.4.0 - Production on Fri Jan 30 10:34:00 2015
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 "APPS"."SYS_EXPORT_TABLE_01":  apps/******** DIRECTORY=dumpdir NETWORK_LINK=touat3 DUMPFILE=test_wq.dmp tables=APPS.TEST_WQ logfile=test_expdp.log 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ
. . exported "APPS"."TEST_WQ"                            1.994 MB   20000 rows
Master table "APPS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for APPS.SYS_EXPORT_TABLE_01 is:
  /u01/test/test_wq.dmp
Job "APPS"."SYS_EXPORT_TABLE_01" successfully completed at Fri Jan 30 10:41:38 2015 elapsed 0 00:07:36

[oravis@szdb06 ~]$ 

生成的文件也是在目标库(本地directory)。 
[root@szdb06 test]# pwd
/u01/test
[root@szdb06 test]# ls -alrt
total 20
drwxr-xr-x 8 root   oinstall 4096 Oct 11 12:10 ..
-rw-r--r-- 1 oravis dba        60 Nov 29 16:20 test_dir.txt
drwxr-xr-x 2 oravis dba      4096 Jan 30 10:34 .
-rw-r----- 1 oravis dba      4096 Jan 30 10:34 test_wq.dmp
-rw-r--r-- 1 oravis dba       527 Jan 30 10:34 test_expdp.log
[root@szdb06 test]# 
请使用浏览器的分享功能分享到微信等