« ORA-39213 Metadata processing not available | Blog首页 | EXPDP:使用ESTIMATE_ONLY参数评估ESTIMATE性能 »
EXPDP测试：性能数据记录
作者：eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接：https://www.eygle.com/archives/2010/12/expdp_performance_record01.html
用户在使用EXPDP进行数据导出备份时，遇到了极大的性能问题，备份极其缓慢。链接：https://www.eygle.com/archives/2010/12/expdp_performance_record01.html
我进行了两个测试，简要记录一下测试结果，测试主机为Linux，2CPU，4G内存,本地硬盘：
10.2.0.2 EXPDP BLOCKS method:5.995 GB，时间：3.5分钟
10.2.0.2 EXPDP BLOCKS method: 22.54 GB ,时间：28分钟
10.2.0.2 EXPDP BLOCKS method: 22.54 GB ,时间：24分钟，并行度为4
以下是测试一，未使用并行：
Export: Release 10.2.0.2.0 - Production on Tuesday, 28 December, 2010 12:03:12测试二：
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."SYS_EXPORT_FULL_01": '/******** AS SYSDBA' directory=backup dumpfile=EYGLE2.dmp full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.995 GB
Processing object type DATABASE_EXPORT/TABLEMMACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLEMMACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_MMEC
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_MMEC
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/JOB
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "EYGLEAPP"."MM_HIS" 4.949 MB 22985 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_HIS_BAK" 450.1 MB 2670748 rows
. . exported "EYGLE100"."MM_SENDINFO_HIS" 203.2 MB 1017328 rows
. . exported "EYGLE200"."MMRECORD_HIS" 380.9 MB 1787737 rows
. . exported "EYGLEAPP"."ENMM_DEBUG" 19.15 MB 205150 rows
. . exported "EYGLE200"."MMRECORD_HIS" 267.6 MB 2521835 rows
. . exported "EYGLEAPP"."LM_LINKID_RESOURCE" 263.2 MB 4121124 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_NZ" 2.206 MB 12100 rows
. . exported "EYGLEAPP"."EYGLE_MM_STAT" 257.4 MB 6036836 rows
. . exported "EYGLEAPP"."MM_HIS" 1.062 MB 12448 rows
. . exported "EYGLE100"."MM_ORIINFO_HIS" 181.0 MB 2335277 rows
. . exported "EYGLE100"."EYGLE_LOG" 1.733 MB 31169 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN_HIS_BAK" 175.9 MB 1640468 rows
. . exported "EYGLE200"."MMREPORT_HIS" 161.1 MB 2030029 rows
. . exported "EYGLE203"."MMRECORD_HIS" 42.66 MB 191059 rows
. . exported "EYGLE104"."MM_SENDINFO_HIS" 106.2 MB 429910 rows
. . exported "EYGLE203"."MMRECORD_HIS" 20.11 MB 196642 rows
. . exported "EYGLEAPP"."LM_MM_SENDINFO_SYN" 23.63 MB 259638 rows
. . exported "EYGLE203"."MMREPORT_HIS" 73.29 MB 925822 rows
. . exported "EYGLE104"."MM_ORIINFO_HIS" 63.80 MB 450218 rows
. . exported "EYGLE200"."MMRECORD" 5.279 MB 23282 rows
. . exported "EYGLE200"."MMRECORD_MMS" 21.95 KB 125 rows
. . exported "EYGLEAPP"."BLACK_LIST" 38.29 MB 1544217 rows
. . exported "EYGLE106"."MM_SENDINFO" 17.03 KB 2 rows
. . exported "EYGLE200"."MMRECORD" 1.295 MB 12581 rows
. . exported "EYGLE200"."MMREPORT" 1.859 MB 23195 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN" 990.8 KB 8820 rows
. . exported "EYGLEAPP"."PROC_LOG" 8.191 MB 166463 rows
. . exported "EYGLEAPP"."MS_RIGOR_EN" 15.11 MB 199049 rows
. . exported "EYGLEAPP"."MM_BAD" 9.017 MB 66770 rows
. . exported "EYGLEAPP"."LM_USERINFO" 6.831 MB 201365 rows
. . exported "EYGLE203"."MMRECORD" 10.52 KB 19 rows
. . exported "EYGLE203"."MMRECORD" 12.69 KB 3 rows
. . exported "EYGLEAPP"."MS_RIGOR" 10.32 MB 154035 rows
. . exported "EYGLEAPP"."TEMP_NUMBER" 11.64 MB 67863 rows
. . exported "EYGLEAPP"."MS_RIGOR_EN_OLD" 10.32 MB 154035 rows
. . exported "EYGLEAPP"."LM_PANKU_USER" 7.430 MB 173270 rows
. . exported "EYGLEAPP"."T_TMP_MMBLE_BLK" 7.341 MB 177509 rows
. . exported "EYGLE102"."MM_SENDINFO_HIS" 5.098 MB 38895 rows
. . exported "EYGLE200"."SUBSCRIPTION" 5.465 MB 45889 rows
. . exported "EYGLE203"."MMREPORT" 7.343 KB 3 rows
. . exported "EYGLEAPP"."LM_WARNMSG" 3.781 MB 15609 rows
. . exported "EYGLE106"."MM_ORIINFO" 11.17 KB 2 rows
. . exported "EYGLEAPP"."ENMM_ORDER" 1.627 MB 32662 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_USERINFO" 2.738 MB 35030 rows
. . exported "EYGLEAPP"."ENMM_ORDER_HIS" 2.454 MB 49950 rows
. . exported "EYGLEAPP"."LM_ORDER_SYN" 1.911 MB 31853 rows
. . exported "EYGLEAPP"."T_TMP_MMBILE" 2.036 MB 177509 rows
. . exported "EYGLEAPP"."SYS_EXPORT_SCHEMA_01" 1.110 MB 1871 rows
. . exported "EYGLEAPP"."LM_SSSH_USER_RECORD" 867.2 KB 21067 rows
. . exported "EYGLEAPP"."MM_BAD" 273.7 KB 3794 rows
. . exported "EYGLEAPP"."USERINFO_TMP" 1.033 MB 48999 rows
. . exported "SYSMAN"."MGMM_METRICS" 553.3 KB 2578 rows
. . exported "SYSMAN"."MGMM_STRING_METRIC_HISTORY" 486.1 KB 4260 rows
. . exported "EYGLEAPP"."TEMP_BLACK_LIST" 432.6 KB 16220 rows
. . exported "EYGLEAPP"."VOOLE_NAME_PASS" 376.0 KB 12979 rows
. . exported "EYGLEAPP"."LM_LOTTERY_CONTENT" 351.4 KB 5844 rows
. . exported "SYSMAN"."MGMM_HC_OS_COMPONENTS" 215.0 KB 653 rows
. . exported "SYSMAN"."MGMM_HC_VENDOR_SW_COMPONENTS" 215.0 KB 653 rows
. . exported "SYSMAN"."MGMM_JOB_CRED_PARAMS" 11.69 KB 18 rows
. . exported "SYSMAN"."MGMM_JOB_PROP_PARAMS" 8.820 KB 12 rows
. . exported "SYSMAN"."MGMM_JOB_STEP_PARAMS" 127.4 KB 1128 rows
. . exported "SYSMAN"."MGMM_METRICS_1HOUR" 213.4 KB 2643 rows
. . exported "SYSMAN"."MGMM_METRICS_RAW" 331.7 KB 4144 rows
. . exported "EYGLE102"."MM_SENDINFO" 18.57 KB 36 rows
. . exported "SYSMAN"."MGMM_JOB_SCHEDULE" 9.437 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_SEC_INFO" 8.046 KB 4 rows
. . exported "SYSMAN"."MGMM_JOB_USER_PARAMS" 6.210 KB 1 rows
. . exported "SYSMAN"."MGMM_SEC_INFO" 5.851 KB 1 rows
. . exported "EYGLE101"."MM_SENDINFO_HIS" 86.58 KB 361 rows
. . exported "EYGLEAPP"."LM_SHIELD_REGION_AREA" 67.82 KB 1237 rows
. . exported "EYGLEAPP"."TEMP_TEST_192" 86.21 KB 2494 rows
. . exported "EYGLEAPP"."WANGMENG_BLACK_LIST" 6.265 KB 44 rows
. . exported "SYSMAN"."MGMM_ARU_PRODUCT_RELEASE_MAP" 39.28 KB 2621 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_MD_COLUMNS" 49.35 KB 508 rows
. . exported "SYSMAN"."MGMM_HC_VENDOR_SW_SUMMARY" 55.97 KB 653 rows
. . exported "SYSMAN"."MGMM_JOB_EXECPLAN" 45.92 KB 366 rows
. . exported "SYSMAN"."MGMM_JOB_PARAM_SOURCE" 28.59 KB 140 rows
. . exported "SYSMAN"."MGMM_JOB_SQL_PARAMS" 6.296 KB 3 rows
. . exported "SYSMAN"."MGMM_JOB_SUBST_PARAMS" 5.664 KB 3 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 9.664 KB 44 rows
. . exported "SYSMAN"."MGMM_METRICS_1DAY" 55.07 KB 620 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE" 57.67 KB 55 rows
. . exported "SYSMAN"."MGMM_SYSTEM_PERFORMANCE_LOG" 50 KB 746 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATION" 12.40 KB 41 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATIONENTRY" 12.13 KB 5 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATIONTYPE" 11.03 KB 15 rows
. . exported "OLAPSYS"."CWM$DOMAIN" 13.10 KB 21 rows
. . exported "OLAPSYS"."CWM$FUNCTION" 11.15 KB 14 rows
. . exported "OLAPSYS"."CWM$MMDEL" 10.86 KB 2 rows
. . exported "OLAPSYS"."CWM$OBJECTTYPE" 11.11 KB 15 rows
. . exported "OLAPSYS"."CWM$PARAMETER" 16.10 KB 5 rows
. . exported "OLAPSYS"."CWM$PROJECT" 9.484 KB 3 rows
. . exported "OLAPSYS"."CWM2$AWCUBELOADPARM" 5.875 KB 1 rows
. . exported "OLAPSYS"."CWM2$AWCUBELOADTYPE" 5.640 KB 2 rows
. . exported "OLAPSYS"."CWM2$AWDIMLOADPARM" 5.960 KB 4 rows
. . exported "OLAPSYS"."CWM2$AWDIMLOADTYPE" 5.656 KB 2 rows
. . exported "OLAPSYS"."CWM2$MRALL_DESCRIPTORS" 6.710 KB 41 rows
. . exported "SCOTT"."DEPT" 5.656 KB 4 rows
. . exported "SCOTT"."EMP" 7.820 KB 14 rows
. . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows
. . exported "EYGLE101"."MM_ORIINFO_HIS" 39.15 KB 441 rows
. . exported "EYGLE102"."MM_ORIINFO_HIS" 24.29 KB 185 rows
. . exported "EYGLE200"."SCANMMSID" 5.281 KB 1 rows
. . exported "EYGLE200"."SCAN_DB_CONNECTION" 4.929 KB 1 rows
. . exported "EYGLEAPP"."ENMM_CMD_MAP" 8.617 KB 65 rows
. . exported "EYGLEAPP"."ENMM_CONFIG" 6.039 KB 4 rows
. . exported "EYGLEAPP"."ENMM_FEE_MAP" 7.929 KB 42 rows
. . exported "EYGLEAPP"."ENMM_INFO" 8.320 KB 45 rows
. . exported "EYGLEAPP"."ENMM_JPSX_UNORDER" 15.97 KB 169 rows
. . exported "EYGLEAPP"."ENMM_LOGIN" 6.304 KB 3 rows
. . exported "EYGLEAPP"."ENMM_MM_RECORD" 7.710 KB 5 rows
. . exported "EYGLEAPP"."ENMM_MSMM_CONTENT" 5.945 KB 1 rows
. . exported "EYGLEAPP"."ENMM_MSMM_CONTROL" 6.296 KB 1 rows
. . exported "EYGLEAPP"."ENMM_MS_ROUTER" 8.5 KB 3 rows
. . exported "EYGLEAPP"."ENMM_ROUTER" 16.39 KB 99 rows
. . exported "EYGLEAPP"."ENMM_TIME_SEED" 4.921 KB 1 rows
. . exported "EYGLEAPP"."KEY_DETAIL" 14.39 KB 130 rows
. . exported "EYGLEAPP"."LM_COOP_CONFIG" 14.71 KB 119 rows
. . exported "EYGLEAPP"."LM_FALANG_REGION_BLACKLIST" 7.093 KB 62 rows
. . exported "EYGLEAPP"."LM_FALANG_WEB_REQUEST" 22.93 KB 69 rows
. . exported "EYGLEAPP"."LM_JPSX_AQGY_USERINFO" 12.55 KB 121 rows
. . exported "EYGLEAPP"."LM_LOTTERY_PRODUCT" 6.890 KB 33 rows
. . exported "EYGLEAPP"."LM_MLQD" 7.812 KB 1 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN_CHANNELINFO" 10.11 KB 43 rows
. . exported "EYGLEAPP"."LM_PLSSB_YD_VOTE_15" 6.968 KB 11 rows
. . exported "EYGLEAPP"."LM_SERVICE_COUNTER" 6.812 KB 10 rows
. . exported "EYGLEAPP"."LM_SHIELD_CHANNEL" 23.04 KB 160 rows
. . exported "EYGLEAPP"."LM_SSSH_CB" 26.78 KB 255 rows
. . exported "EYGLEAPP"."LM_TEMP" 8.007 KB 21 rows
. . exported "EYGLEAPP"."LM_VOTE_TESTMMBILE" 5.25 KB 21 rows
. . exported "EYGLEAPP"."LM_YP_MINING" 14.71 KB 82 rows
. . exported "EYGLEAPP"."SERVICE_INFO" 10.53 KB 47 rows
. . exported "EYGLEAPP"."SGW_INFO" 7.656 KB 9 rows
. . exported "EYGLEAPP"."EYGLE_CRYM_HUMMR" 5.593 KB 3 rows
. . exported "EYGLEAPP"."EYGLE_PRO_RESTART" 5.242 KB 1 rows
. . exported "EYGLEAPP"."EYGLE_SYN_RESTART" 5.242 KB 1 rows
. . exported "EYGLEAPP"."TEMP_587_NOMM" 12.94 KB 130 rows
. . exported "SYSMAN"."AQ$_MGMM_NOTIFY_QTABLE_S" 7.781 KB 2 rows
. . exported "SYSMAN"."ESM_COLLECTION" 6.867 KB 32 rows
. . exported "SYSMAN"."MGMM_ADMIN_LICENSES" 5 KB 5 rows
. . exported "SYSMAN"."MGMM_ARU_FAMILY_PRODUCT_MAP" 12.41 KB 579 rows
. . exported "SYSMAN"."MGMM_ARU_LANGUAGES" 5.921 KB 37 rows
. . exported "SYSMAN"."MGMM_ARU_OUI_COMPONENTS" 18.12 KB 319 rows
. . exported "SYSMAN"."MGMM_ARU_PLATFORMS" 7.968 KB 49 rows
. . exported "SYSMAN"."MGMM_ARU_PRODUCTS" 24.64 KB 524 rows
. . exported "SYSMAN"."MGMM_ARU_RELEASES" 9.796 KB 301 rows
. . exported "SYSMAN"."MGMM_AVAILABILITY" 6.656 KB 11 rows
. . exported "SYSMAN"."MGMM_AVAILABILITY_MARKER" 5.718 KB 5 rows
. . exported "SYSMAN"."MGMM_BLACKOUT_PROXY_TARGETS" 5.046 KB 5 rows
. . exported "SYSMAN"."MGMM_BLACKOUT_REASON" 5.265 KB 1 rows
. . exported "SYSMAN"."MGMM_COLLECTION_PROPERTIES" 6.5 KB 4 rows
. . exported "SYSMAN"."MGMM_CREATED_USERS" 5.695 KB 4 rows
. . exported "SYSMAN"."MGMM_CREDENTIALS2" 7.101 KB 3 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_SETS" 7.992 KB 8 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_SET_COLUMNS" 8.390 KB 18 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPES" 6.789 KB 4 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPE_COLUMNS" 8.132 KB 8 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPE_REF" 7.179 KB 1 rows
. . exported "SYSMAN"."MGMM_CURRENT_AVAILABILITY" 6.070 KB 5 rows
. . exported "SYSMAN"."MGMM_CURRENT_METRICS" 25.31 KB 310 rows
. . exported "SYSMAN"."MGMM_CURRENT_SEVERITY" 9.789 KB 1 rows
. . exported "SYSMAN"."MGMM_DB_CONTROLFILES_ECM" 7.593 KB 6 rows
. . exported "SYSMAN"."MGMM_DB_DATAFILES_ECM" 8.25 KB 10 rows
. . exported "SYSMAN"."MGMM_DB_DBNINSTANCEINFO_ECM" 8.062 KB 2 rows
. . exported "SYSMAN"."MGMM_DB_HDM_METRIC_HELPER" 5.601 KB 1 rows
. . exported "SYSMAN"."MGMM_DB_INIT_PARAMS_ECM" 33.35 KB 516 rows
. . exported "SYSMAN"."MGMM_DB_LICENSE_ECM" 6.554 KB 2 rows
. . exported "SYSMAN"."MGMM_DB_RECTSSETTINGS_ECM" 6.375 KB 2 rows
. . exported "SYSMAN"."MGMM_DB_REDOLOGS_ECM" 8.156 KB 6 rows
. . exported "SYSMAN"."MGMM_DB_ROLLBACK_SEGS_ECM" 10.00 KB 2 rows
. . exported "SYSMAN"."MGMM_DB_SGA_ECM" 6.304 KB 18 rows
. . exported "SYSMAN"."MGMM_DB_TABLEMMACES_ECM" 9.554 KB 10 rows
. . exported "SYSMAN"."MGMM_ECM_ARU_MAP" 7.304 KB 22 rows
. . exported "SYSMAN"."MGMM_ECM_GEN_SNAPSHOT" 10.83 KB 12 rows
. . exported "SYSMAN"."MGMM_ECM_RESOURCES" 6.523 KB 14 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT" 8.523 KB 1 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_MD_TABLES" 12.43 KB 78 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_METADATA" 12.79 KB 36 rows
. . exported "SYSMAN"."MGMM_ECM_SNAP_COMPONENT_INFO" 6.093 KB 4 rows
. . exported "SYSMAN"."MGMM_EMCRYPTO_SEED" 4.960 KB 1 rows
. . exported "SYSMAN"."MGMM_EMD_PING" 8.796 KB 1 rows
. . exported "SYSMAN"."MGMM_FAILOVER_CALLBACKS" 5.015 KB 2 rows
. . exported "SYSMAN"."MGMM_HA_INFO_ECM" 6.578 KB 2 rows
. . exported "SYSMAN"."MGMM_HA_MMTR" 5.578 KB 1 rows
. . exported "SYSMAN"."MGMM_HA_RMAN_CONFIG_ECM" 5.632 KB 2 rows
. . exported "SYSMAN"."MGMM_HC_CPU_DETAILS" 7.078 KB 4 rows
. . exported "SYSMAN"."MGMM_HC_FS_MMUNT_DETAILS" 6.601 KB 9 rows
. . exported "SYSMAN"."MGMM_HC_HARDWARE_MASTER" 8.468 KB 1 rows
. . exported "SYSMAN"."MGMM_HC_IOCARD_DETAILS" 7.109 KB 10 rows
. . exported "SYSMAN"."MGMM_HC_NIC_DETAILS" 7.757 KB 4 rows
. . exported "SYSMAN"."MGMM_HC_OS_PROPERTIES" 33.88 KB 439 rows
. . exported "SYSMAN"."MGMM_HC_OS_SUMMARY" 7.257 KB 1 rows
. . exported "SYSMAN"."MGMM_HC_SYSTEM_SUMMARY" 6.843 KB 1 rows
. . exported "SYSMAN"."MGMM_INV_COMPONENT" 33.90 KB 107 rows
. . exported "SYSMAN"."MGMM_INV_CONTAINER" 7 KB 2 rows
. . exported "SYSMAN"."MGMM_INV_DEPENDENCY_RULE" 13.65 KB 218 rows
. . exported "SYSMAN"."MGMM_INV_PATCHSET" 7.609 KB 1 rows
. . exported "SYSMAN"."MGMM_INV_VERSIONED_PATCH" 24.94 KB 69 rows
. . exported "SYSMAN"."MGMM_JOB" 9.632 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_COMMAND" 7.648 KB 30 rows
. . exported "SYSMAN"."MGMM_JOB_EVENT" 5.289 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_EXECUTION" 12.83 KB 3 rows
. . exported "SYSMAN"."MGMM_JOB_EXEC_SUMMARY" 9.453 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_HISTORY" 12.51 KB 3 rows
. . exported "SYSMAN"."MGMM_JOB_NESTED_JOB_TARGETS" 6.320 KB 4 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_CRITERIA" 5.906 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_POLICIES" 5.304 KB 2 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_VALUES" 5.664 KB 1 rows
. . exported "SYSMAN"."MGMM_JOB_SINGLE_TARGET_TYPES" 5.429 KB 7 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_DIMMLAY_INFO" 7.085 KB 31 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_DIMMLAY_PARAM" 10.73 KB 172 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_INFO" 9.523 KB 53 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_URI_INFO" 9.234 KB 61 rows
. . exported "SYSMAN"."MGMM_JOB_VALUE_PARAMS" 6.828 KB 23 rows
. . exported "SYSMAN"."MGMM_LICENSABLE_TARGET_TYPES" 5.570 KB 11 rows
. . exported "SYSMAN"."MGMM_LICENSE_DEFINITIONS" 7.015 KB 5 rows
. . exported "SYSMAN"."MGMM_LOGIN_ASSISTANTS" 5.765 KB 2 rows
. . exported "SYSMAN"."MGMM_MASTER_CHANGED_CALLBACK" 5.617 KB 1 rows
. . exported "SYSMAN"."MGMM_METADATA_SETS" 6.796 KB 19 rows
. . exported "SYSMAN"."MGMM_METRICS_EXT" 9.179 KB 20 rows
. . exported "SYSMAN"."MGMM_METRIC_COLLECTIONS" 20.58 KB 102 rows
. . exported "SYSMAN"."MGMM_METRIC_COLLECTIONS_REP" 6.078 KB 9 rows
. . exported "SYSMAN"."MGMM_METRIC_DEPENDENCY_DEF" 7 KB 13 rows
. . exported "SYSMAN"."MGMM_METRIC_THRESHOLDS" 25.44 KB 209 rows
. . exported "SYSMAN"."MGMM_NOTIFY_PROFILES" 6.25 KB 3 rows
. . exported "SYSMAN"."MGMM_NOTIFY_QUEUES" 5.531 KB 24 rows
. . exported "SYSMAN"."MGMM_NOTIFY_RULES" 12.72 KB 6 rows
. . exported "SYSMAN"."MGMM_NOTIFY_RULE_CONFIGS" 10.14 KB 30 rows
. . exported "SYSMAN"."MGMM_OMS_PARAMETERS" 6.320 KB 7 rows
. . exported "SYSMAN"."MGMM_PARAMETERS" 6.406 KB 6 rows
. . exported "SYSMAN"."MGMM_PERFORMANCE_NAMES" 7.960 KB 43 rows
. . exported "SYSMAN"."MGMM_POLICY_GROUP" 8.593 KB 6 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE_CRITERIA" 6.578 KB 7 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE_DEF_COLUMNS" 16.86 KB 111 rows
. . exported "SYSMAN"."MGMM_POLICY_SNAPSHOT_CRITERIA" 6.5 KB 19 rows
. . exported "SYSMAN"."MGMM_POLICY_TARGET_CRITERIA" 6.546 KB 9 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATIONS" 6.273 KB 6 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATION_ROWS" 8.156 KB 11 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATION_VALUES" 7.218 KB 25 rows
. . exported "SYSMAN"."MGMM_PRIVS" 7.539 KB 19 rows
. . exported "SYSMAN"."MGMM_PRIV_GRANTS" 7.015 KB 10 rows
. . exported "SYSMAN"."MGMM_PRIV_INCLUDES" 5.609 KB 12 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY" 9.203 KB 12 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY_GROUP" 5.867 KB 7 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY_TARGET_STATE" 8.703 KB 44 rows
. . exported "SYSMAN"."MGMM_REBUILD_INDEXES" 5.585 KB 1 rows
. . exported "SYSMAN"."MGMM_ROLES" 5.25 KB 1 rows
. . exported "SYSMAN"."MGMM_ROLE_GRANTS" 5.960 KB 1 rows
. . exported "SYSMAN"."MGMM_SEVERITY" 34.07 KB 125 rows
. . exported "SYSMAN"."MGMM_TARGETS" 13.69 KB 5 rows
. . exported "SYSMAN"."MGMM_TARGET_ADD_CALLBACKS" 5.304 KB 1 rows
. . exported "SYSMAN"."MGMM_TARGET_CREDENTIALS" 5.929 KB 1 rows
. . exported "SYSMAN"."MGMM_TARGET_DELETE_CALLBACKS" 5.234 KB 7 rows
. . exported "SYSMAN"."MGMM_TARGET_DELETE_EXCEPTIONS" 5.148 KB 8 rows
. . exported "SYSMAN"."MGMM_TARGET_PROPERTIES" 8.453 KB 45 rows
. . exported "SYSMAN"."MGMM_TARGET_PROP_DEFS" 8.601 KB 14 rows
. . exported "SYSMAN"."MGMM_TARGET_ROLLUP_TIMES" 10.88 KB 110 rows
. . exported "SYSMAN"."MGMM_TARGET_TYPES" 7.507 KB 23 rows
. . exported "SYSMAN"."MGMM_TARGET_TYPE_COMPONENT_MAP" 6.046 KB 4 rows
. . exported "SYSMAN"."MGMM_TYPE_PROPERTIES" 6.523 KB 26 rows
. . exported "SYSMAN"."MGMM_USER_CALLBACKS" 5.382 KB 4 rows
. . exported "SYSMAN"."MGMM_USER_CONTEXT" 5.609 KB 4 rows
. . exported "SYSMAN"."MGMM_USER_FOLDERS" 6.343 KB 18 rows
. . exported "SYSMAN"."MGMM_USER_JOBS" 5.25 KB 1 rows
. . exported "SYSMAN"."MGMM_USER_TYPE_METRIC_PREFS" 6.171 KB 7 rows
. . exported "SYSMAN"."MGMM_VERSIONS" 6.242 KB 2 rows
. . exported "SYSMAN"."MGMM_VIEW_USER_CREDENTIALS" 5.328 KB 1 rows
. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 5.953 KB 2 rows
. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.507 KB 28 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.648 KB 19 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.296 KB 3 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 5.914 KB 2 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
/data2/EYGLE/backup/EYGLE2.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 12:06:45
Export: Release 10.2.0.2.0 - Production on Tuesday, 28 December, 2010 14:35:17
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "EYGLEEN"."SYS_EXPORT_SCHEMA_01": EYGLEEN/******** directory=backup dumpfile=sms1.dmp parallel=4 schemas=EYGLEEN
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 22.54 GB
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
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/JOB
. . exported "EYGLEEN"."ME_HIS" 3.225 GB 15407777 rows
. . exported "EYGLEEN"."MD_HIS" 1.314 GB 16534402 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201008" 1004. MB 4292993 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201009" 786.1 MB 3370471 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201007" 724.8 MB 3099001 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_HOUR" 655.6 MB 9025188 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201010" 653.5 MB 2850395 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201006" 575.7 MB 2462481 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201005" 573.9 MB 2451156 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201004" 536.1 MB 2285741 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201011" 511.1 MB 2227920 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201008" 475.5 MB 4571123 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201001" 460.5 MB 1955281 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201008" 431.3 MB 4984605 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201004" 407.2 MB 3870854 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201002" 404.7 MB 3746486 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201009" 397.4 MB 3840547 rows
. . exported "EYGLEEN"."EYGLE_MM_MOMT_HIS" 391.6 MB 1471931 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201009" 341.9 MB 3951024 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201002" 344.9 MB 1463691 rows
. . exported "EYGLEEN"."SMGLT_MM_MOMT_HIS" 326.1 MB 1563310 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201005" 322.1 MB 3104846 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201010" 312.3 MB 2938475 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201001" 305.7 MB 2670432 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201007" 304.8 MB 2943506 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201006" 301.9 MB 2928212 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201007" 299.7 MB 3463427 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201010" 280.1 MB 3236689 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201011" 264.7 MB 2447075 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201012" 241.9 MB 1021948 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201005" 232.8 MB 2689503 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201006" 233.7 MB 2701199 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_HOUR" 217.5 MB 2136969 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201011" 221.5 MB 2559363 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201004" 215.1 MB 2484694 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201001" 203.5 MB 2350487 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201003" 186.9 MB 793578 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201003" 144.6 MB 1374989 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201002" 138.4 MB 1598489 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201012" 113.2 MB 1053049 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201012" 100.2 MB 1157968 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201003" 74.93 MB 864827 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201007" 52.29 MB 198402 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_DAY" 39.26 MB 386623 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_DAY" 28.12 MB 397104 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201007" 23.20 MB 296351 rows
. . exported "EYGLEEN"."EYGLEEN_MOMTCHANNEL_DAY" 18.58 MB 192715 rows
. . exported "EYGLEEN"."MS_RIGOR_EN" 15.11 MB 199053 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201009" 15.28 MB 55044 rows
. . exported "EYGLEEN"."EYGLEEN_MOMTCHANNEL_MONTH" 8.889 MB 91378 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201008" 13.96 MB 51363 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201010" 14.45 MB 52219 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201012" 9.945 MB 36728 rows
. . exported "EYGLEEN"."EYGLEEN_ORDERCHANNEL_DAY" 9.850 MB 107503 rows
. . exported "EYGLEEN"."EYGLEEN_FEILONG_AREA" 9.155 MB 150846 rows
. . exported "EYGLEEN"."APP_TOUSU" 8.157 MB 21987 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201003" 7.898 MB 29049 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_TEST" 11.64 KB 6 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201001" 6.099 MB 24153 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201005" 6.187 MB 22921 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201011" 6.457 MB 23984 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201008" 5.581 MB 77689 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201004" 4.811 MB 18158 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201009" 3.821 MB 54789 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201010" 3.576 MB 50994 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201005" 2.643 MB 37951 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201002" 2.865 MB 10701 rows
. . exported "EYGLEEN"."EYGLEEN_FEILONG_DAY" 2.880 MB 34645 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201003" 1.849 MB 26258 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201012" 2.441 MB 35606 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201001" 1.299 MB 20086 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201004" 1.181 MB 16705 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201011" 1.560 MB 22631 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_MONTH" 1.088 MB 15498 rows
. . exported "EYGLEEN"."T_BMS_LOG_ACT" 1.128 MB 27902 rows
. . exported "EYGLEEN"."T_BMS_LOG_IN" 928.6 KB 24637 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201002" 679.3 KB 9309 rows
. . exported "EYGLEEN"."EYGLEEN_ORDERCHANNEL_MONTH" 452.8 KB 4713 rows
. . exported "EYGLEEN"."ERROR_CODE" 184.2 KB 3064 rows
. . exported "EYGLEEN"."SMGLT_FINANCE_ORDER_MONTH" 87.89 KB 1533 rows
. . exported "EYGLEEN"."APP_INFO" 8.062 KB 38 rows
. . exported "EYGLEEN"."APP_TIMESEND_CONTENT" 6.812 KB 11 rows
. . exported "EYGLEEN"."APP_TIMESEND_TASK" 7.781 KB 1 rows
. . exported "EYGLEEN"."APP_TOUSU_CHANNEL" 22.36 KB 87 rows
. . exported "EYGLEEN"."BMS_ADMIN" 16.29 KB 63 rows
. . exported "EYGLEEN"."BMS_BASIC_ITEM" 21.68 KB 144 rows
. . exported "EYGLEEN"."BMS_COMPANY" 6.976 KB 8 rows
. . exported "EYGLEEN"."BMS_GROUP" 6.921 KB 14 rows
. . exported "EYGLEEN"."BMS_MENU" 22.32 KB 835 rows
. . exported "EYGLEEN"."SERVICE_INFO" 10.36 KB 44 rows
. . exported "EYGLEEN"."SERVICE_INFO_MMS_WAP" 6.421 KB 25 rows
. . exported "EYGLEEN"."SGW_INFO" 7.656 KB 9 rows
. . exported "EYGLEEN"."EYGLEEN_CHANNEL_INFO" 11.96 KB 28 rows
. . exported "EYGLEEN"."YPYD_AREA_CODE" 5.648 KB 32 rows
. . exported "EYGLEEN"."YPYD_ZXF_TEMP" 22.44 KB 839 rows
Master table "EYGLEEN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for EYGLEEN.SYS_EXPORT_SCHEMA_01 is:
/data3/backup/sms1.dmp
Job "EYGLEEN"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:59:19
测试数据留存！供参考！
历史上的今天...
>> 2015-12-29文章:
>> 2012-12-29文章:
>> 2008-12-29文章:
>> 2007-12-29文章:
>> 2006-12-29文章:
>> 2005-12-29文章:
>> 2004-12-29文章:
By eygle on 2010-12-29 09:43 | Comments (4) | FAQ | 2687 |
如果11g，加上compression=all会更快
如果11g，加上compression=all会更快
曾经用ibm 750导入压缩前有120G数据的表，6分钟
服务器是关键，核心竞争力啊！