欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

expdp_导出多个路径

程序员文章站 2022-04-29 22:05:04
...

[bin.liu@enmoteam3 ~]$ expdp travel/aa DUMPFILE=AWR_DIR:dmp1,D_TEST:dmp2 parallel=2 Export: Release 11.2.0.4.0 - Production on Fri Sep 5 13:37:38 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected t

[bin.liu@enmoteam3 ~]$ expdp travel/aa DUMPFILE=AWR_DIR:dmp1,D_TEST:dmp2 parallel=2
 
Export: Release 11.2.0.4.0 - Production on Fri Sep 5 13:37:38 2014
 
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
FLASHBACK automatically enabled to preserve database integrity.
Starting "TRAVEL"."SYS_EXPORT_SCHEMA_01":  travel/******** DUMPFILE=AWR_DIR:dmp1,D_TEST:dmp2 parallel=2 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 232.6 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
. . exported "TRAVEL"."TESTTABLE"                        199.2 MB 1988400 rows
. . exported "TRAVEL"."REDO"                             484.8 KB   23387 rows
. . exported "TRAVEL"."TEST2"                            5.421 KB       1 rows
. . exported "TRAVEL"."REDO_LOG"                             0 KB       0 rows
. . exported "TRAVEL"."TEST":"TEST_PART01"                   0 KB       0 rows
. . exported "TRAVEL"."TEST":"TEST_PART02"                   0 KB       0 rows
. . exported "TRAVEL"."TEST":"TEST_PART03"                   0 KB       0 rows
. . exported "TRAVEL"."TEST1"                                0 KB       0 rows
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Master table "TRAVEL"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TRAVEL.SYS_EXPORT_SCHEMA_01 is:
  /tmp/dmp1.dmp
  /home/oracle/dmp2.dmp
Job "TRAVEL"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Sep 5 13:38:52 2014 elapsed 0 00:01:11
 
[bin.liu@enmoteam3 ~]$ su - oracle
Password: 
[oracle@enmoteam3 ~]$ 
[oracle@enmoteam3 ~]$ ls -l dmp2.dmp 
-rw-r----- 1 oracle oinstall 209633280 Sep  5 13:38 dmp2.dmp
[oracle@enmoteam3 ~]$ ls -l /tmp/dmp1.dmp 
-rw-r----- 1 oracle oinstall 28672 Sep  5 13:38 /tmp/dmp1.dmp
[oracle@enmoteam3 ~]$