17,377
社区成员
发帖
与我相关
我的任务
分享
u2@EMREP> conn u1/u1
Connected.
u1@EMREP> select * from t;
N NAME
---------- --------------------
1 a
2 b
3 c
[oracle@localhost ~]$ expdp u1/u1@emrep directory=dumpdir dumpfile=test.dmp
Export: Release 10.2.0.1.0 - Production on Sunday, 02 December, 2012 21:16:52
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 "U1"."SYS_EXPORT_SCHEMA_01": u1/********@emrep directory=dumpdir dumpfile=test.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "U1"."T" 5.234 KB 3 rows
Master table "U1"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for U1.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/test.dmp
Job "U1"."SYS_EXPORT_SCHEMA_01" successfully completed at 21:17:29
[oracle@localhost ~]$ impdp u2/u2@emrep directory=dumpdir dumpfile=test.dmp remap_schema=u1:u2
Import: Release 10.2.0.1.0 - Production on Sunday, 02 December, 2012 21:20:43
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
Master table "U2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2"."SYS_IMPORT_FULL_01": u2/********@emrep directory=dumpdir dumpfile=test.dmp remap_schema=u1:u2
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "U2"."T" 5.234 KB 3 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "U2"."SYS_IMPORT_FULL_01" successfully completed at 21:20:52
u1@EMREP> conn u2/u2
Connected.
u2@EMREP> select * from t;
N NAME
---------- --------------------
1 a
2 b
3 c