Home > Database > Mysql Tutorial > expdp_导出多个路径

expdp_导出多个路径

WBOY
Release: 2016-06-07 16:37:55
Original
1271 people have browsed it

[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 ~]$
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template