oracle如何快速复制schema,【impdp方式简单复制一个schema到另一个schema到】

[oracle@databak ~]$ export ORACLE_SID=gc

[oracle@databak ~]$ impdp system/oracle network_link=dblink SCHEMAS=ccod REMAP_SCHEMA=ccod:tt REMAP_TABLESPACE=ccod:ocm

Import: Release 10.2.0.1.0 - Production on Wednesday, 28 November, 2012 16:37:36

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** network_link=dblink SCHEMAS=ccod REMAP_SCHEMA=ccod:tt REMAP_TABLESPACE=ccod:ocm

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 1.625 MB

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/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . imported "TT"."CCOD_SYS_MENU"                            38 rows

. . imported "TT"."CCOD_SYS_ROLE"                             2 rows

. . imported "TT"."CCOD_SYS_USER"                             1 rows

. . imported "TT"."CFG_NODE"                                  2 rows

. . imported "TT"."DCMS_DOMAIN_MANAGER"                       1 rows

. . imported "TT"."DCMS_LOGIN_USER"                           3 rows

. . imported "TT"."DCMS_MANAGEMENT"                           1 rows

. . imported "TT"."DCMS_MENU"                                82 rows

. . imported "TT"."DCMS_USER_MENU"                          189 rows

. . imported "TT"."GLS_ACCOUNT_NUMBER"                        1 rows

. . imported "TT"."GLS_DB_AGENT_RELATE"                     202 rows

. . imported "TT"."GLS_DB_ENT_RELATE"                         1 rows

. . imported "TT"."GLS_DB_SG_RELATE"                          4 rows

. . imported "TT"."GLS_DB_SOURCE"                             1 rows

. . imported "TT"."GLS_ENTERPRISE_INFO"                       1 rows

. . imported "TT"."GLS_LOG_FILTER_COLUMN"                     4 rows

. . imported "TT"."GLS_LOG_FILTER_OBJ"                        1 rows

. . imported "TT"."GLS_MONITOR_CONFIG"                        1 rows

. . imported "TT"."GLS_OPERATION_LOG"                        92 rows

. . imported "TT"."GLS_OPERATION_LOG_DETAIL"                 12 rows

. . imported "TT"."GLS_PARAMETER"                             3 rows

. . imported "TT"."GLS_RESOURCE_NUM"                          2 rows

. . imported "TT"."GLS_SERVICE_ROUTE"                         2 rows

. . imported "TT"."GLS_SERVICE_UNIT"                          8 rows

. . imported "TT"."GLS_SS_CONFIG"                             1 rows

. . imported "TT"."SUBO"                                     10 rows

. . imported "TT"."CCOD_SYS_MENU_ROLE"                        0 rows

. . imported "TT"."CCOD_SYS_USER_ROLE"                        0 rows

. . imported "TT"."CFG_ALTER_INFO"                            0 rows

. . imported "TT"."CFG_SMS_LOG"                               0 rows

. . imported "TT"."EC_CLUSTER_AREA"                           0 rows

. . imported "TT"."EC_CLUSTER_INFO"                           0 rows

. . imported "TT"."EC_CLUSTER_RELA"                           0 rows

. . imported "TT"."EC_EXCEL_INFO"                             0 rows

. . imported "TT"."EC_EXCEL_RELA"                             0 rows

. . imported "TT"."EC_RI_CONFIG"                              0 rows

. . imported "TT"."EC_VGPROXY_INFO"                           0 rows

. . imported "TT"."EC_VGPROXY_TAC"                            0 rows

. . imported "TT"."EC_VGPT_RELA"                              0 rows

. . imported "TT"."GLS_C_E_RELATION"                          0 rows

. . imported "TT"."GLS_DATA_CLEAN"                            0 rows

. . imported "TT"."GLS_ILDTLICENSE"                           0 rows

. . imported "TT"."GLS_INT_COUNTRY_PHONE"                     0 rows

. . imported "TT"."GLS_INT_PROVINCE_PHONE"                    0 rows

. . imported "TT"."GLS_VIRTUAL_ENT"                           0 rows

. . imported "TT"."GLS_VIRTUAL_ENT_RELATION"                  0 rows

. . imported "TT"."OCX_UPDATE_LOG"                            0 rows

. . imported "TT"."PROXY_AGENT_INFO"                          0 rows

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/TYPE/TYPE_BODY

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 16:37:54