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 ~]$
原文地址:expdp_导出多个路径, 感谢原作者分享。
上一篇: Oracle 函数 与 存储过程 的应用
推荐阅读
-
快剪辑怎么更改视频默认导出位置?快剪辑更改默认导出文件路径教程
-
edge收藏夹路径在哪里?edge浏览器收藏夹导出方法图解
-
PHPExcel实现表格导出功能示例【带有多个工作sheet】
-
word导出pdf格式后怎么隐藏图片路径?
-
怎么快速把多个文件夹的照片批量导出到一个文件夹里?
-
AI怎么拆分字?AI一个画板的文件导出成多个文件的方法
-
360浏览器扩展插件如何导出独立保存? 360浏览器插件下载方法及保存路径介绍
-
lua中使用packagepath解决多个项目的路径冲突问题
-
laravel maatwebsite/Excel导出多个sheet
-
C# NPOI大数据量导出多个sheet的Excel