• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

expdp_导出多个路径

mysql 搞代码 4年前 (2022-01-09) 13次浏览 已收录 0个评论

[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 ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsFLASHBACK 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_DATATotal estimation using BLOCKS method: 232.6 MBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing 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 rowsProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/DB_LINKProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_<i style="color:transparent">本文来源gaodai$ma#com搞$代*码*网(</i>EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSMaster 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.dmpJob "TRAVEL"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Sep 5 13:38:52 2014 elapsed 0 00:01:11 [bin.liu@enmoteam3 ~]$ su - oraclePassword: [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 ~]$

搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:expdp_导出多个路径
喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址