oracle expdp parallel,【EXPDP】运用PARALLEL 和FILESIZE参数提高备份效率

Mon Mar 29 13:36:38 GMT 2010Export: Release 10.2.0.3.0 - Production on Mon Mar 29 13:36:38 2010Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport done in AL32UTF8 character set and UTF8 NCHAR character setAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user SEC. exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user SECAbout to export SEC's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export SEC's tables via Conventional Path .... . exporting table           SEC_ATTACH_VPDS_TEMP         37 rows exported. . exporting table         SEC_CHANGE_DEGDSE_TEMP      67915 rows exported……省略……. . exporting table                T_SEC_SDE_RESES          0 rows exported. exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully without warnings.Mon Mar 29 13:45:12 GMT 2010Export: Release 10.2.0.3.0 - 64bit Production on Monday, 29 March, 2010 13:45:12Copyright (c) 2003, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsStarting "SEC"."SYS_EXPORT_SCHEMA_01":  SEC/******** directory=expdp_dir dumpfile=SEC_expdp_%U.dmp logfile=SEC_expdp.log filesize=500m parallel=4Estimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 1.110 GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE. . exported "SEC"."T_SEC_DAC_LOG"                  94.67 MB 1984475 rows. . exported "SEC"."T_SEC_AGRTT_APPLY"              93.57 MB  572489 rows……省略……. . exported "SEC"."T_VSE_CLD_PDESOD"               19.25 KB     282 rows. . exported "SEC"."T_VSE_SEC_RLELE_DAY_TYPE"       9.296 KB      18 rowsProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCHEMA_EXPORT/FUNCTION/FUNCTIONProcessing object type SCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTIONProcessing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSMaster table "SEC"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:/expdp/SEC_expdp_01.dmp/expdp/SEC_expdp_02.dmp/expdp/SEC_expdp_03.dmp/expdp/SEC_expdp_04.dmpJob "SEC"."SYS_EXPORT_SCHEMA_01" successfully completed at 13:45:59Mon Mar 29 13:46:00 GMT 2010

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值