导出语法:
exp baoxian/baoxian@10.6.12.247:1521/devdb file=c:\devdb.dmp full=y
exp baoxian/baoxian@10.6.12.247:1521/devdb file=c:\devdbuser.dmp owner=(baoxian)
导入语法:
imp baoxian/baoxian@orcl full=y file=c:\devdbuser.dmp ignore=y
过程输出:
C:\Documents and Settings\ibm>exp baoxian/baoxian@10.6.12.247:1521/devdb file=c:
\devdb.dmp full=y
Export: Release 10.1.0.2.0 - Production on 星期二 6月 1 09:54:29 2010
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. . exporting table MGMT_BCN_AVAIL_LOG 0 rows exported
. . exporting table MGMT_BCN_TARGET 0 rows exported
. . exporting table MGMT_BCN_TARGET_LOCK 0 rows exported
. . exporting table MGMT_BCN_TARGET_TXN 0 rows exported
. . exporting table MGMT_BCN_TXN_DEFN 0 rows exported
. . exporting table MGMT_BCN_TXN_HTTP 0 rows exported
. . exporting table MGMT_BCN_TXN_HTTP_PARAM 0 rows exported
. . exporting table MGMT_BCN_TXN_PING 0 rows exported
. . exporting table MGMT_BLACKOUTS 0 rows exported
. . exporting table MGMT_BLACKOUT_FLAT_TARGETS 0 rows exported
. . exporting table MGMT_BLACKOUT_HISTORY 0 rows exported
. . exporting table MGMT_BLACKOUT_PROXY_TARGETS 5 rows exported
. . exporting table MGMT_BLACKOUT_REASON 1 rows exported
. . exporting table MGMT_BLACKOUT_SCHEDULE 0 rows exported
. . exporting table MGMT_BLACKOUT_STATE 0 rows exported
. . exporting table MGMT_BLACKOUT_TARGET_DETAILS 0 rows exported
. . exporting table MGMT_BLACKOUT_WINDOWS 0 rows exported
. . exporting table MGMT_BUG_ADVISORY 0 rows exported
. . exporting table MGMT_BUG_ADVISORY_BUG 0 rows exported
. . exporting table MGMT_BUG_ADV_HOME_PATCH 0 rows exported
. . exporting table MGMT_BUG_AVAILABLE_PATCH 0 rows exported
. . exporting table MGMT_BUG_FIX_APPLICABLE_COMP 0 rows exported
. . exporting table MGMT_BUG_FIX_APPLIC_COMP_LIST 0 rows exported
. . exporting table MGMT_BUG_PATCH_FIXES_BUG 0 rows exported
. . exporting table MGMT_BUG_PATCH_PLATFORM 0 rows exported
. . exporting table MGMT_CHANGE_AGENT_URL 0 rows exported
. . exporting table MGMT_COLLECTION_CREDENTIALS 0 rows exported
. . exporting table MGMT_COLLECTION_PROPERTIES 4 rows exported
. . exporting table MGMT_COMP_RESULT_TO_JOB_MAP 0 rows exported
. . exporting table MGMT_COMP_TARGET_DEF 0 rows exported
. . exporting table MGMT_CONTAINER_CREDENTIALS 0 rows exported
. . exporting table MGMT_CREATED_USERS 4 rows exported
. . exporting table MGMT_CREDENTIALS 0 rows exported
. . exporting table MGMT_CREDENTIALS2 3 rows exported
. . exporting table MGMT_CREDENTIAL_SETS 8 rows exported
. . exporting table MGMT_CREDENTIAL_SET_COLUMNS 18 rows exported
. . exporting table MGMT_CREDENTIAL_TYPES 4 rows exported
. . exporting table MGMT_CREDENTIAL_TYPE_COLUMNS 8 rows exported
. . exporting table MGMT_CREDENTIAL_TYPE_COL_VALS 0 rows exported
. . exporting table MGMT_CREDENTIAL_TYPE_REF 1 rows exported
. . exporting table MGMT_CURRENT_AVAILABILITY 5 rows exported
. . exporting table MGMT_CURRENT_METRICS 191 rows exported
. . exporting table MGMT_CURRENT_METRIC_ERRORS 0 rows exported
. . exporting table MGMT_CURRENT_SEVERITY 1 rows exported
. . exporting table MGMT_DBNET_TNS_ADMINS 0 rows exported
. . exporting table MGMT_DB_CONTROLFILES_ECM 3 rows exported
. . exporting table MGMT_DB_DATAFILES_ECM 7 rows exported
. . exporting table MGMT_DB_DBNINSTANCEINFO_ECM 1 rows exported
. . exporting table MGMT_DB_FEATUREUSAGE 62 rows exported
. . exporting table MGMT_DB_HDM_METRIC_HELPER 1 rows exported
. . exporting table MGMT_DB_INIT_PARAMS_ECM 257 rows exported
. . exporting table MGMT_DB_INVOBJS_ECM 0 rows exported
. . exporting table MGMT_DB_LATEST_HDM_FINDINGS 0 rows exported
. . exporting table MGMT_DB_LICENSE_ECM 1 rows exported
. . exporting table MGMT_DB_RECSEGMENTSETTINGS_ECM 28 rows exported
. . exporting table MGMT_DB_RECTSSETTINGS_ECM 1 rows exported
. . exporting table MGMT_DB_RECUSERSETTINGS_ECM 0 rows exported
. . exporting table MGMT_DB_REDOLOGS_ECM 3 rows exported
. . exporting table MGMT_DB_ROLLBACK_SEGS_ECM 1 rows exported
. . exporting table MGMT_DB_SGA_ECM 9 rows exported
. . exporting table MGMT_DB_TABLESPACES_ECM 7 rows exported
. . exporting table MGMT_DELTA_COMPARISON_DELTAS 0 rows exported
. . exporting table MGMT_DELTA_COMP_DELTA_DETAILS 0 rows exported
. . exporting table MGMT_DELTA_COMP_KEY_COLS 0 rows exported
. . exporting table MGMT_DELTA_COMP_PROPERTIES 0 rows exported
. . exporting table MGMT_DELTA_COMP_SUMMARIES 0 rows exported
. . exporting table MGMT_DELTA_SUMMARY_ERRORS 0 rows exported
. . exporting table MGMT_DELTA_ENTRY 156 rows exported
. . exporting table MGMT_DELTA_ENTRY_VALUES 39 rows exported
. . exporting table MGMT_DELTA_IDS 68 rows exported
. . exporting table MGMT_DELTA_ID_VALUES 183 rows exported
. . exporting table MGMT_DELTA_SAVED_COMPARISON 0 rows exported
. . exporting table MGMT_DELTA_SNAP 503 rows exported
. . exporting table MGMT_DIROBJ_USERS_HOTLIST 0 rows exported
. . exporting table MGMT_DUPLICATE_TARGETS 0 rows exported
. . exporting table MGMT_E2E_DETAILS 0 rows exported
. . exporting table MGMT_E2E_DETAILS_1DAY 0 rows exported
. . exporting table MGMT_E2E_DETAILS_1HOUR 0 rows exported
. . exporting table MGMT_E2E_JDBC 0 rows exported
. . exporting table MGMT_E2E_JDBC_1DAY 0 rows exported
. . exporting table MGMT_E2E_JDBC_1HOUR 0 rows exported
. . exporting table MGMT_E2E_SQL 0 rows exported
. . exporting table MGMT_E2E_SQL_1DAY 0 rows exported
. . exporting table MGMT_E2E_SQL_1HOUR 0 rows exported
. . exporting table MGMT_E2E_SQL_CONN 0 rows exported
. . exporting table MGMT_E2E_SQL_STMT 0 rows exported
. . exporting table MGMT_E2E_SUMMARY 0 rows exported
. . exporting table MGMT_E2E_SUMMARY_1DAY 0 rows exported
. . exporting table MGMT_E2E_SUMMARY_1HOUR 0 rows exported
. . exporting table MGMT_ECM_ARU_MAP 22 rows exported
. . exporting table MGMT_ECM_CSA 0 rows exported
. . exporting table MGMT_ECM_CSA_COOKIES 0 rows exported
. . exporting table MGMT_ECM_CSA_CUSTOM 0 rows exported
. . exporting table MGMT_ECM_CSA_GENERAL_INFO 0 rows exported
. . exporting table MGMT_ECM_CSA_SNAPSHOT_INFO 0 rows exported
. . exporting table MGMT_ECM_GEN_SNAPSHOT 7 rows exported
. . exporting table MGMT_ECM_HOST_CONFIGS_TO_DEL 0 rows exported
. . exporting table MGMT_ECM_HW 0 rows exported
. . exporting table MGMT_ECM_HW_CPU 0 rows exported
. . exporting table MGMT_ECM_HW_IOCARD 0 rows exported
. . exporting table MGMT_ECM_HW_NIC 0 rows exported
. . exporting table MGMT_ECM_LOADED_FILES 0 rows exported
. . exporting table MGMT_ECM_OS 0 rows exported
. . exporting table MGMT_ECM_OS_COMPONENT 0 rows exported
. . exporting table MGMT_ECM_OS_FILESYSTEM 0 rows exported
. . exporting table MGMT_ECM_OS_PROPERTY 0 rows exported
. . exporting table MGMT_ECM_OS_REGISTERED_SW 0 rows exported
. . exporting table MGMT_ECM_OS_REGISTERED_SW_COMP 0 rows exported
. . exporting table MGMT_ECM_PATCH_CACHE 0 rows exported
. . exporting table MGMT_ECM_RESOURCES 14 rows exported
. . exporting table MGMT_ECM_SNAPSHOT 1 rows exported
. . exporting table MGMT_ECM_SNAPSHOT_MD_COLUMNS 508 rows exported
. . exporting table MGMT_ECM_SNAPSHOT_MD_TABLES 78 rows exported
. . exporting table MGMT_ECM_SNAPSHOT_METADATA 36 rows exported
. . exporting table MGMT_ECM_SNAP_COMPONENT_INFO 4 rows exported
. . exporting table MGMT_EMCRYPTO_SEED 1 rows exported
. . exporting table MGMT_EMD_PING 1 rows exported
. . exporting table MGMT_ENTERPRISE_CREDENTIALS 0 rows exported
. . exporting table MGMT_FAILOVER_CALLBACKS 2 rows exported
. . exporting table MGMT_FAILOVER_TABLE 1 rows exported
. . exporting table MGMT_FLAT_TARGET_MEMBERSHIPS 0 rows exported
. . exporting table MGMT_HA_BACKUP 0 rows exported
. . exporting table MGMT_HA_CLS_INTR_CONN 0 rows exported
. . exporting table MGMT_HA_FILES_ECM 0 rows exported
. . exporting table MGMT_HA_INFO_ECM 1 rows exported
. . exporting table MGMT_HA_INIT_PARAMS_ECM 0 rows exported
. . exporting table MGMT_HA_MTTR 1 rows exported
. . exporting table MGMT_HA_RAC_INTR_CONN 0 rows exported
. . exporting table MGMT_HA_RMAN_CONFIG_ECM 1 rows exported
. . exporting table MGMT_HC_CPU_DETAILS 4 rows exported
. . exporting table MGMT_HC_FS_MOUNT_DETAILS 4 rows exported
. . exporting table MGMT_HC_HARDWARE_MASTER 1 rows exported
. . exporting table MGMT_HC_IOCARD_DETAILS 1 rows exported
. . exporting table MGMT_HC_NIC_DETAILS 2 rows exported
. . exporting table MGMT_HC_OS_COMPONENTS 1 rows exported
. . exporting table MGMT_HC_OS_PROPERTIES 31 rows exported
. . exporting table MGMT_HC_OS_SUMMARY 1 rows exported
. . exporting table MGMT_HC_SYSTEM_SUMMARY 1 rows exported
. . exporting table MGMT_HC_VENDOR_SW_COMPONENTS 0 rows exported
. . exporting table MGMT_HC_VENDOR_SW_SUMMARY 15 rows exported
. . exporting table MGMT_HOST_CREDENTIALS 0 rows exported
. . exporting table MGMT_INDEX_SIZES 0 rows exported
. . exporting table MGMT_INV_COMPONENT 114 rows exported
. . exporting table MGMT_INV_COMPONENT_PATCH 0 rows exported
. . exporting table MGMT_INV_CONTAINER 2 rows exported
. . exporting table MGMT_INV_CONTAINER_PROPERTY 0 rows exported
. . exporting table MGMT_INV_DEPENDENCY_RULE 230 rows exported
. . exporting table MGMT_INV_FILE 0 rows exported
. . exporting table MGMT_INV_PATCH 0 rows exported
. . exporting table MGMT_INV_PATCHED_FILE 0 rows exported
. . exporting table MGMT_INV_PATCHED_FILE_COMP 0 rows exported
. . exporting table MGMT_INV_PATCHSET 0 rows exported
. . exporting table MGMT_INV_PATCH_FIXED_BUG 0 rows exported
. . exporting table MGMT_INV_VERSIONED_PATCH 0 rows exported
. . exporting table MGMT_JOB 1 rows exported
. . exporting table MGMT_JOB_BLACKOUT_ASSOC 0 rows exported
. . exporting table MGMT_JOB_CALLBACKS 0 rows exported
. . exporting table MGMT_JOB_COMMAND 30 rows exported
. . exporting table MGMT_JOB_CREDENTIALS 0 rows exported
. . exporting table MGMT_JOB_CRED_PARAMS 18 rows exported
. . exporting table MGMT_JOB_EMD_STATUS_QUEUE 0 rows exported
. . exporting table MGMT_JOB_EVENT 1 rows exported
. . exporting table MGMT_JOB_EXECPLAN 366 rows exported
. . exporting table MGMT_JOB_EXECUTION 3 rows exported
. . exporting table MGMT_JOB_EXEC_EVENT_PARAMS 0 rows exported
. . exporting table MGMT_JOB_EXEC_LOCKS 0 rows exported
. . exporting table MGMT_JOB_EXEC_SUMMARY 8 rows exported
. . exporting table MGMT_JOB_EXT_TARGETS 0 rows exported
. . exporting table MGMT_JOB_FLAT_TARGETS 0 rows exported
. . exporting table MGMT_JOB_HISTORY 24 rows exported
. . exporting table MGMT_JOB_LARGE_PARAMS 0 rows exported
. . exporting table MGMT_JOB_LOCK_INFO 0 rows exported
. . exporting table MGMT_JOB_LOCK_TARGETS 0 rows exported
. . exporting table MGMT_JOB_NESTED_JOB_TARGETS 4 rows exported
. . exporting table MGMT_JOB_OUTPUT 7 rows exported
. . exporting table MGMT_JOB_PARAMETER 0 rows exported
. . exporting table MGMT_JOB_PARAM_SOURCE 140 rows exported
. . exporting table MGMT_JOB_PROP_PARAMS 12 rows exported
. . exporting table MGMT_JOB_PURGE_CRITERIA 1 rows exported
. . exporting table MGMT_JOB_PURGE_POLICIES 2 rows exported
. . exporting table MGMT_JOB_PURGE_TARGETS 0 rows exported
. . exporting table MGMT_JOB_PURGE_VALUES 1 rows exported
. . exporting table MGMT_JOB_QUEUES 0 rows exported
. . exporting table MGMT_JOB_SCHEDULE 1 rows exported
. . exporting table MGMT_JOB_SEC_INFO 4 rows exported
. . exporting table MGMT_JOB_SINGLE_TARGET_TYPES 7 rows exported
. . exporting table MGMT_JOB_SQL_PARAMS 3 rows exported
. . exporting table MGMT_JOB_STEP_COMMAND_LOG 0 rows exported
. . exporting table MGMT_JOB_STEP_PARAMS 1128 rows exported
. . exporting table MGMT_JOB_STEP_TARGETS 0 rows exported
. . exporting table MGMT_JOB_SUBST_PARAMS 3 rows exported
. . exporting table MGMT_JOB_TARGET 0 rows exported
. . exporting table MGMT_JOB_TYPE_DISPLAY_INFO 31 rows exported
. . exporting table MGMT_JOB_TYPE_DISPLAY_PARAM 172 rows exported
. . exporting table MGMT_JOB_TYPE_INFO 53 rows exported
. . exporting table MGMT_JOB_TYPE_URI_INFO 61 rows exported
. . exporting table MGMT_JOB_USER_PARAMS 1 rows exported
. . exporting table MGMT_JOB_VALUE_PARAMS 23 rows exported
. . exporting table PARAM_VALUES_TAB 44 rows exported
. . exporting table MGMT_LICENSABLE_TARGET_TYPES 11 rows exported
. . exporting table MGMT_LICENSES 0 rows exported
. . exporting table MGMT_LICENSE_DEFINITIONS 5 rows exported
. . exporting table MGMT_LOGIN_ASSISTANTS 2 rows exported
. . exporting table MGMT_LONG_TEXT 0 rows exported
. . exporting table MGMT_MASTER_AGENT 0 rows exported
. . exporting table MGMT_MASTER_CHANGED_CALLBACK 1 rows exported
. . exporting table MGMT_METADATA_SETS 18 rows exported
. . exporting table MGMT_METRICS 2438 rows exported
. . exporting table MGMT_METRICS_1DAY 3891 rows exported
. . exporting table MGMT_METRICS_1HOUR 19198 rows exported
. . exporting table MGMT_METRICS_COMPOSITE_KEYS 0 rows exported
. . exporting table MGMT_METRICS_EXT 20 rows exported
. . exporting table MGMT_METRICS_RAW 19257 rows exported
. . exporting table MGMT_METRIC_COLLECTIONS 99 rows exported
. . exporting table MGMT_METRIC_COLLECTIONS_REP 9 rows exported
. . exporting table MGMT_METRIC_DEPENDENCY 0 rows exported
. . exporting table MGMT_METRIC_DEPENDENCY_DEF 13 rows exported
. . exporting table MGMT_METRIC_DEPENDENCY_DETAILS 0 rows exported
. . exporting table MGMT_METRIC_ERRORS 0 rows exported
. . exporting table MGMT_METRIC_THRESHOLDS 207 rows exported
. . exporting table MGMT_NOTIFICATION_LOG 0 rows exported
. . exporting table MGMT_NOTIFY_DEVICES 0 rows exported
. . exporting table MGMT_NOTIFY_DEVICE_PARAMS 0 rows exported
. . exporting table MGMT_NOTIFY_DEV_SCHEDULES 0 rows exported
. . exporting table MGMT_NOTIFY_EMAIL_GATEWAY 0 rows exported
. . exporting table MGMT_NOTIFY_NOTIFYEES 0 rows exported
. . exporting table MGMT_NOTIFY_PROFILES 3 rows exported
. . exporting table MGMT_NOTIFY_QTABLE 0 rows exported
. . exporting table MGMT_NOTIFY_QUEUES 24 rows exported
. . exporting table MGMT_NOTIFY_REQUEUE 0 rows exported
. . exporting table MGMT_NOTIFY_RULES 6 rows exported
. . exporting table MGMT_NOTIFY_RULE_CONFIGS 30 rows exported
. . exporting table MGMT_NOTIFY_SCHEDULES 0 rows exported
. . exporting table MGMT_OB_ADMIN_CLIENT_DB 0 rows exported
. . exporting table MGMT_OB_ADMIN_HOSTS 0 rows exported
. . exporting table MGMT_OMS_PARAMETERS 7 rows exported
. . exporting table MGMT_OSM_DISK_GROUP_ECM 0 rows exported
. . exporting table MGMT_PARAMETERS 6 rows exported
. . exporting table MGMT_PERFORMANCE_NAMES 43 rows exported
. . exporting table MGMT_PLANPROBLEM_FACTORS 0 rows exported
. . exporting table MGMT_POLICY_ERRORS 68 rows exported
. . exporting table MGMT_POLICY_GROUP 6 rows exported
. . exporting table MGMT_POLICY_PARAMS 0 rows exported
. . exporting table MGMT_POLICY_RULE 55 rows exported
. . exporting table MGMT_POLICY_RULE_CRITERIA 7 rows exported
. . exporting table MGMT_POLICY_RULE_DEF_COLUMNS 111 rows exported
. . exporting table MGMT_POLICY_RULE_DEF_PARAMS 0 rows exported
. . exporting table MGMT_POLICY_SNAPSHOT_CRITERIA 19 rows exported
. . exporting table MGMT_POLICY_TARGET_CRITERIA 9 rows exported
. . exporting table MGMT_POLICY_VIOLATIONS 9 rows exported
. . exporting table MGMT_POLICY_VIOLATION_ROWS 68 rows exported
. . exporting table MGMT_POLICY_VIOLATION_VALUES 363 rows exported
. . exporting table MGMT_PORTLET_PREFERENCE_STORE 0 rows exported
. . exporting table MGMT_PRIVS 19 rows exported
. . exporting table MGMT_PRIV_GRANTS 10 rows exported
. . exporting table MGMT_PRIV_INCLUDES 12 rows exported
. . exporting table MGMT_PURGE_POLICY 12 rows exported
. . exporting table MGMT_PURGE_POLICY_GROUP 7 rows exported
. . exporting table MGMT_PURGE_POLICY_TARGET_STATE 44 rows exported
. . exporting table MGMT_RCVCAT_CONFIG 0 rows exported
. . exporting table MGMT_RCVCAT_REPOS 0 rows exported
. . exporting table MGMT_REBUILD_INDEXES 1 rows exported
. . exporting table MGMT_ROLES 1 rows exported
. . exporting table MGMT_ROLE_GRANTS 1 rows exported
. . exporting table MGMT_SEC_INFO 1 rows exported
. . exporting table MGMT_SEVERITY 1980 rows exported
. . exporting table MGMT_SPACE_METRICS 2 rows exported
. . exporting table MGMT_SQLPROBLEM_FACTORS 0 rows exported
. . exporting table MGMT_SQL_BIND_VARS 0 rows exported
. . exporting table MGMT_SQL_EVALUATION 0 rows exported
. . exporting table MGMT_SQL_METRIC_HELPER 0 rows exported
. . exporting table MGMT_SQL_PLAN 0 rows exported
. . exporting table MGMT_SQL_REUSE 0 rows exported
. . exporting table MGMT_SQL_SUMMARY 0 rows exported
. . exporting table MGMT_STRING_METRIC_HISTORY 6340 rows exported
. . exporting table MGMT_SYSTEM_ERROR_LOG 3 rows exported
. . exporting table MGMT_SYSTEM_PERFORMANCE_LOG 1024 rows exported
. . exporting table MGMT_TABLE_SIZES 0 rows exported
. . exporting table MGMT_TARGETS 5 rows exported
. . exporting table MGMT_TARGETS_DELETE 0 rows exported
. . exporting table MGMT_TARGET_ADD_CALLBACKS 1 rows exported
. . exporting table MGMT_TARGET_AGENT_ASSOC 0 rows exported
. . exporting table MGMT_TARGET_ASSOC 0 rows exported
. . exporting table MGMT_TARGET_ASSOC_INSTANCE 0 rows exported
. . exporting table MGMT_TARGET_BASELINES 0 rows exported
. . exporting table MGMT_TARGET_BASELINES_DATA 0 rows exported
. . exporting table MGMT_TARGET_CREDENTIALS 1 rows exported
. . exporting table MGMT_TARGET_DELETE_CALLBACKS 7 rows exported
. . exporting table MGMT_TARGET_DELETE_EXCEPTIONS 8 rows exported
. . exporting table MGMT_TARGET_MEMBERSHIPS 0 rows exported
. . exporting table MGMT_TARGET_PROPERTIES 45 rows exported
. . exporting table MGMT_TARGET_PROP_DEFS 12 rows exported
. . exporting table MGMT_TARGET_ROLLUP_TIMES 110 rows exported
. . exporting table MGMT_TARGET_TYPES 23 rows exported
. . exporting table MGMT_TARGET_TYPE_COMPONENT_MAP 4 rows exported
. . exporting table MGMT_TYPE_PROPERTIES 26 rows exported
. . exporting table MGMT_UPDATE_CREDENTIALS_DATA 0 rows exported
. . exporting table MGMT_UPDATE_OPERATIONS 0 rows exported
. . exporting table MGMT_UPDATE_OPERATIONS_DATA 0 rows exported
. . exporting table DW_CUS_TYP_INFO 0 rows exported
. . exporting table DW_ORG_INFO 1 rows exported
. . exporting table DW_ORG_INFO_BAK 0 rows exported
. . exporting table DW_T_CAP_INFO 0 rows exported
. . exporting table DW_T_CUST_INFO 0 rows exported
. . exporting table DW_T_DEP_INFO 0 rows exported
. . exporting table DW_T_V_TJJGX 0 rows exported
. . exporting table DW_T_V_TJJGX_DQR 0 rows exported
. . exporting table DW_T_V_TJJR 0 rows exported
. . exporting table DW_T_V_TKHHF_DQR 0 rows exported
. . exporting table DW_V_TBMLB 0 rows exported
. . exporting table EGATEOPERATESEQ 25313 rows exported
. . exporting table EGATE_MONITOR 6 rows exported
. . exporting table EGATE_SEQ_VIEW 583 rows exported
. . exporting table EXPERTPARAMETERLIST 4 rows exported
. . exporting table FLOW_CC_INFO 840 rows exported
. . exporting table FLOW_CUSTOMERCOMPLAIN_INFO 109 rows exported
. . exporting table FLOW_FILE_UPLOAD 147 rows exported
. . exporting table FLOW_HK_CZGD 25 rows exported
. . exporting table FLOW_HK_FQFK 83 rows exported
. . exporting table FLOW_HK_GSLS 0 rows exported
. . exporting table FLOW_HK_GZGD 53 rows exported
. . exporting table FLOW_HK_JJGD 81 rows exported
. . exporting table FLOW_HK_JJK 0 rows exported
. . exporting table FLOW_HK_KHTS 27 rows exported
. . exporting table FLOW_HK_LCGD 44 rows exported
. . exporting table FLOW_HK_LEAVE 33 rows exported
. . exporting table FLOW_HK_TBGD 19 rows exported
. . exporting table FLOW_HK_XYK 106 rows exported
. . exporting table FLOW_LEAVE_INFO 735 rows exported
. . exporting table FLOW_QC_APPEAL 129 rows exported
. . exporting table FLOW_USER_LEAVE_INFO 0 rows exported
. . exporting table FUNDINFO 323 rows exported
. . exporting table HIS_COORDINATE 813 rows exported
. . exporting table HIS_CUSTOMERCOMPLAIN 0 rows exported
. . exporting table HK_DKMONEYRATE 413 rows exported
. . exporting table HK_MONEYRATE 1315 rows exported
. . exporting table HK_PRCPDTABLE 115 rows exported
. . exporting table HK_VOUCHERBOND 89 rows exported
. . exporting table HUNTINFO 2 rows exported
. . exporting table INB_MEDIA_SOLD 3 rows exported
. . exporting table IP_ARC_GRANT 1041 rows exported
. . exporting table IP_ARC_SECURITY_STRATEGY 5 rows exported
. . exporting table IP_ARC_USER_AUTH 53 rows exported
. . exporting table IP_AUDIT_LOG 1212 rows exported
. . exporting table IP_BIZ_CATEGORY 1 rows exported
. . exporting table IP_CODE_INFO 20 rows exported
. . exporting table IP_CODE_TYPE 5 rows exported
. . exporting table IP_I18N_RESOURCE 92 rows exported
. . exporting table IP_PROCESS_BIZ 376 rows exported
. . exporting table IP_PROCESS_CONFIG 1 rows exported
. . exporting table IP_RES_FUNCTION 11 rows exported
. . exporting table IP_RES_GROUP 0 rows exported
. . exporting table IP_RES_MENU 589 rows exported
. . exporting table IP_RES_MENU_SHOUXIAN 474 rows exported
. . exporting table IP_RES_MENU_YINGHANG 478 rows exported
. . exporting table IP_RES_RELATION 1399 rows exported
. . exporting table IP_RES_UNITRULE 2 rows exported
. . exporting table IP_RES_URL 5920 rows exported
. . exporting table MEDIAINFO 1 rows exported
. . exporting table MENU_TREES 0 rows exported
. . exporting table MLOG$_EGATEOPERATESEQ 418338 rows exported
. . exporting table MONITORCLUSTER 2 rows exported
. . exporting table MONITOR_CTI_INFO 4 rows exported
. . exporting table MONITOR_HUNT_HIS 4 rows exported
. . exporting table MONITOR_HUNT_INFO 2 rows exported
. . exporting table MONITOR_MEDIAGW_HIS 2 rows exported
. . exporting table MONITOR_MEDIAGW_INFO 1 rows exported
. . exporting table MONITOR_PBX_HIS 40 rows exported
. . exporting table MONITOR_PBX_INFO 20 rows exported
. . exporting table MONITOR_PBX_PARAMINFO 8 rows exported
. . exporting table MONITOR_PBX_TIMEPARAMETER 1 rows exported
. . exporting table MONITOR_SERVERBASEINFO 2 rows exported
. . exporting table MONITOR_SERVER_PARASETING 0 rows exported
. . exporting table MONITOR_TKPORT_HIS 12 rows exported
. . exporting table MONITOR_TKPORT_INFO 6 rows exported
. . exporting table MONITOR_TRUNK_HIS 4 rows exported
. . exporting table MONITOR_TRUNK_INFO 2 rows exported
. . exporting table NOTE 0 rows exported
. . exporting table OPERATORSPEAKLIST 16 rows exported
. . exporting table PBXINFO 1 rows exported
. . exporting table PCI_QUESTION_BASE 1 rows exported
. . exporting table PCI_SYS_VALIDATE 10 rows exported
. . exporting table PUBLICPARAMETERLIST 2 rows exported
. . exporting table QUEUEPARAMTER 3 rows exported
. . exporting table REC_RECORD 5 rows exported
. . exporting table RP_AGENT_15_STAT 391 rows exported
. . exporting table RP_AGENT_30_STAT 239 rows exported
. . exporting table RP_AGENT_HOUR_STAT 142 rows exported
. . exporting table RP_AGENT_STAT 25 rows exported
. . exporting table RP_CC_STAT 0 rows exported
. . exporting table RP_ROUTE_15_STAT 62 rows exported
. . exporting table RP_ROUTE_30_STAT 38 rows exported
. . exporting table RP_ROUTE_HOUR_STAT 22 rows exported
. . exporting table RP_ROUTE_STAT 5 rows exported
. . exporting table RP_SKILL_TEAM_15_STAT 166 rows exported
. . exporting table RP_SKILL_TEAM_30_STAT 45 rows exported
. . exporting table RP_SKILL_TEAM_HOUR_STAT 61 rows exported
. . exporting table RP_SKILL_TEAM_STAT 7 rows exported
. . exporting table RUPD$_EGATEOPERATESEQ
. . exporting table SYSTEMPARAMTER 1 rows exported
. . exporting table TCOUNTCONNECT 0 rows exported
. . exporting table TCUSTGRADE 1 rows exported
. . exporting table TEMPPICTURES 0 rows exported
. . exporting table TENDSUM 1 rows exported
. . exporting table TRUNKINFO 2 rows exported
. . exporting table TRUNKPORTINFO 0 rows exported
. . exporting table TR_ALLOWERROR 0 rows exported
. . exporting table TR_AUDIT 0 rows exported
. . exporting table TR_DATASET 0 rows exported
. . exporting table TR_EXTATTR 0 rows exported
. . exporting table TR_EXTMETRIC 0 rows exported
. . exporting table TR_FREEREPORT 0 rows exported
. . exporting table TR_FRULE 0 rows exported
. . exporting table TR_GLOBALPARAM 4 rows exported
. . exporting table TR_GLOBALTABITEM 0 rows exported
. . exporting table TR_INTERVAL 8 rows exported
. . exporting table TR_METRICCELL 0 rows exported
. . exporting table TR_METRICLIBINFO 0 rows exported
. . exporting table TR_REPORT 0 rows exported
. . exporting table TR_REPORTINFO 0 rows exported
. . exporting table TR_REPORTMAP 0 rows exported
. . exporting table TR_REPORTOPLOG 0 rows exported
. . exporting table TR_REPORTTABPARAM 0 rows exported
. . exporting table TR_REPORTTEMPLATE 0 rows exported
. . exporting table TR_RPTSTATEHIS 0 rows exported
. . exporting table TR_RULE 0 rows exported
. . exporting table TR_SUMMARYINFO 0 rows exported
. . exporting table TR_TABITEM 0 rows exported
. . exporting table T_AP_CUBE 0 rows exported
. . exporting table T_AP_CUSTOM_MEMBER 0 rows exported
. . exporting table T_AP_DATASOURCE 0 rows exported
. . exporting table T_AP_DIM 0 rows exported
. . exporting table T_AP_FORMATTER 0 rows exported
. . exporting table T_AP_HIERARCHY 0 rows exported
. . exporting table T_AP_LEVEL_SETTING 0 rows exported
. . exporting table T_AP_MEMBER_SETTING 0 rows exported
. . exporting table T_AP_NAMED_SET 0 rows exported
. . exporting table T_AP_PARAMETER 0 rows exported
. . exporting table T_AP_PURVIEW 0 rows exported
. . exporting table T_AP_QUERY 0 rows exported
. . exporting table T_AP_QUERYCHART 0 rows exported
. . exporting table T_AP_WARNING_STYLE 0 rows exported
. . exporting table T_BASICFIELD 13 rows exported
. . exporting table T_BASICPROC 0 rows exported
. . exporting table T_BASICPROCFIELD 0 rows exported
. . exporting table T_BASICPROCPARAM 0 rows exported
. . exporting table T_BASICTABLE 2 rows exported
. . exporting table T_BIZATTR 0 rows exported
. . exporting table T_BIZATTRPARA 0 rows exported
. . exporting table T_BIZOBJECT 0 rows exported
. . exporting table T_BIZTHEME 0 rows exported
. . exporting table T_BIZVIEW 0 rows exported
. . exporting table T_BIZVIEWFIELD 26 rows exported
. . exporting table T_CALCFIELD 0 rows exported
. . exporting table T_CHART 0 rows exported
. . exporting table T_DATAFORMAT 6 rows exported
. . exporting table T_DATASOURCE 1 rows exported
. . exporting table T_DATATYPE_PARA 6 rows exported
. . exporting table T_DBFUNCTION 79 rows exported
. . exporting table T_DEMO 10 rows exported
. . exporting table T_DP_CHART 0 rows exported
. . exporting table T_DP_DASHLET 0 rows exported
. . exporting table T_DP_FAVORITES 0 rows exported
. . exporting table T_DP_LAYOUT 9 rows exported
. . exporting table T_DP_PAGE 0 rows exported
. . exporting table T_DP_PAGEINTERACT 0 rows exported
. . exporting table T_DP_PAGERULES 0 rows exported
. . exporting table T_DP_PARAMMAPPING 0 rows exported
. . exporting table T_DP_STYLE 2 rows exported
. . exporting table T_DP_USER_CONFIG 0 rows exported
. . exporting table T_DP_USR_DASHLET 0 rows exported
. . exporting table T_DP_USR_PG_LYT 0 rows exported
. . exporting table T_EMPTYCLOB
. . exporting table T_EXCELTEMPLATE 0 rows exported
. . exporting table T_FILERESOURCE 0 rows exported
. . exporting table T_FILTER 0 rows exported
. . exporting table T_FUNCLIST 159 rows exported
. . exporting table T_GROUPATTR 0 rows exported
. . exporting table T_GROUPEXP 2 rows exported
. . exporting table T_GROUP_ROLE 1 rows exported
. . exporting table T_HIERINFO 1 rows exported
. . exporting table T_JAVAQUERYDEFINE 2 rows exported
. . exporting table T_JUMPRULE 0 rows exported
. . exporting table T_MACROGUIDE 2 rows exported
. . exporting table T_MACROMODULE 7 rows exported
. . exporting table T_MAPAREA 383 rows exported
. . exporting table T_MAP_EXCHILDAREA 0 rows exported
. . exporting table T_METADATA 0 rows exported
. . exporting table T_MYFAVORITE 0 rows exported
. . exporting table T_OPERATIONLOG 3471 rows exported
. . exporting table T_PARAMETER 6 rows exported
. . exporting table T_PORTAL 0 rows exported
. . exporting table T_PUBLISH_CATALOG 0 rows exported
. . exporting table T_PUBLISH_THEME 0 rows exported
. . exporting table T_REPORT 0 rows exported
. . exporting table T_RESAUDIT 0 rows exported
. . exporting table T_RESOURCEPACK 3 rows exported
. . exporting table T_RESTREE 230 rows exported
. . exporting table T_ROLE 4 rows exported
. . exporting table T_ROLE_FUNC 381 rows exported
. . exporting table T_ROWPERMISSION 0 rows exported
. . exporting table T_SCHEDULE 1 rows exported
. . exporting table T_SCHEDULELOG 0 rows exported
. . exporting table T_SCHEDULETASK 0 rows exported
. . exporting table T_SESSION 0 rows exported
. . exporting table T_SESSIONCONFIG 0 rows exported
. . exporting table T_SYSTEMCONFIG 14 rows exported
. . exporting table T_TABLELINK 0 rows exported
. . exporting table T_TABLELINKVIEW 0 rows exported
. . exporting table T_TASK 2 rows exported
. . exporting table T_TASKLOG 0 rows exported
. . exporting table T_TEMPTABLE 0 rows exported
. . exporting table T_TEST 1 rows exported
. . exporting table T_TRANSFORMRULE 0 rows exported
. . exporting table T_URLLINK 0 rows exported
. . exporting table T_USERATTR 0 rows exported
. . exporting table T_USERCONFIG 0 rows exported
. . exporting table T_USERPROPERTY 0 rows exported
. . exporting table T_USER_ROLE 4 rows exported
. . exporting table WCT_AGENT_LOGIN_INFO 1 rows exported
. . exporting table WCT_CUST_LOGIN_INFO 2 rows exported
. . exporting table WCT_MESSAGE_LIST 1 rows exported
. . exporting table WCT_SESSION_INFO 0 rows exported
. . exporting table WCT_TEMPIMAGE 0 rows exported
. . exporting table WF_ACTIVITY 2472 rows exported
. . exporting table WF_ASSIGNCONTEXT 3175 rows exported
. . exporting table WF_ASSIGNDESCRIPTION 595 rows exported
. . exporting table WF_ASSIGNPOLICY 595 rows exported
. . exporting table WF_CALENDAR 1 rows exported
. . exporting table WF_CONFIG 53 rows exported
. . exporting table WF_CONFIGCATEGORY 11 rows exported
. . exporting table WF_CONSUMEDEVENT 0 rows exported
. . exporting table WF_DESIGNMAPPING 11 rows exported
. . exporting table WF_DESIGNPOLICY 83 rows exported
. . exporting table WF_DESIGNTEMPLATE 85 rows exported
. . exporting table WF_DEVOLVE 2 rows exported
. . exporting table WF_DISTRIBUTEDSERVER 0 rows exported
. . exporting table WF_DUTY 586 rows exported
. . exporting table WF_ENGINEMANAGEMENT 1 rows exported
. . exporting table WF_EVENTQUEUE 0 rows exported
. . exporting table WF_EVENTWATCH 0 rows exported
. . exporting table WF_EXPLICITREPORTPATH 136 rows exported
. . exporting table WF_GROUP 4 rows exported
. . exporting table WF_GROUPMEMBER 9 rows exported
. . exporting table WF_LOG 41498 rows exported
. . exporting table WF_MAIL 7 rows exported
. . exporting table WF_NODE 645 rows exported
. . exporting table WF_NODEACTION 547 rows exported
. . exporting table WF_NODECONFIG 22 rows exported
. . exporting table WF_NODEEVENTWATCH 0 rows exported
. . exporting table WF_NODETIMER 0 rows exported
. . exporting table WF_NODEVARIABLE 0 rows exported
. . exporting table WF_PACKAGE 12 rows exported
. . exporting table WF_POSITION 87 rows exported
. . exporting table WF_PROCESS 741 rows exported
. . exporting table WF_PROCESSEXCEPTION 139 rows exported
. . exporting table WF_PROCESSLOCK 1112 rows exported
. . exporting table WF_PROCESSTIMERCTRL 0 rows exported
. . exporting table WF_PROCESSVARIABLE 5880 rows exported
. . exporting table WF_PROCESSVARIABLEOBJECT 0 rows exported
. . exporting table WF_ROLE 16 rows exported
. . exporting table WF_ROUTE 989 rows exported
. . exporting table WF_SHAREDDEFINITION 0 rows exported
. . exporting table WF_STAFF 55 rows exported
. . exporting table WF_STAFFWORKLOAD 0 rows exported
. . exporting table WF_SUBFLOWCALL 0 rows exported
. . exporting table WF_TASK 2039 rows exported
. . exporting table WF_TASKCONTEXT 0 rows exported
. . exporting table WF_TASKVARMAPPING 0 rows exported
. . exporting table WF_TEMPLATE 90 rows exported
. . exporting table WF_TEMPLATEGRAPHICS 80 rows exported
. . exporting table WF_TEMPLATEVARIABLE 263 rows exported
. . exporting table WF_TIMERINFO 89 rows exported
. . exporting table WF_TIMERINFOHISTORY 645 rows exported
. . exporting table WF_TRANSITION 3182 rows exported
. . exporting table WF_UNIT 42 rows exported
. about to export YH_YX's tables via Conventional Path ...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.
C:\Documents and Settings\ibm>
C:\Documents and Settings\ibm>
导入时,有可能发生错误,因为需要的用户或表空间可能不存在。
这时候你根据错误提示,创建用户和表空间,再执行导入就可以了。
//创建需要的表空间COMIX_DATA
CREATE TABLESPACE COMIX_DATA
LOGGING
DATAFILE 'D:\oracle10g\oradata\COMIX_DATA.DBF'
SIZE 100M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
//创建需要的用户 baoxian
-- Create the user
create user baoxian
identified by baoxian
default tablespace COMIX_DATA
temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant dba to baoxian;