expdp_导出多个路径

php中文网
发布: 2016-06-07 16:37:55
原创
1480人浏览过

[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 ~]$
登录后复制
最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新 English
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号