您好,欢迎来到爱玩科技网。
搜索
您的当前位置:首页expdp_导出多个路径

expdp_导出多个路径

来源:爱玩科技网


[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 - bit 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 ~]$

Copyright © 2019- aiwanbo.com 版权所有 赣ICP备2024042808号-3

违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务