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]#
[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]#