oracle远程数据库导出实例

导出语法:

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;


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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值