EX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
. . exported "U1"."FAMILY" 5.984 KB 2 rows
Master table "U1"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for U1.SYS_EXPORT_TABLESPACE_01 is:
/oracle/backup/u1_u1.dump
Job "U1"."SYS_EXPORT_TABLESPACE_01" successfully completed at 13:29:34
#通过表空间导入(remap_tablespace remap_user)
[oracle@host2 ~]$ impdp u2/tiger dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3
[oracle@host2 ~]$ impdp u2/tiger dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3
Import: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:39:35
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "U2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2"."SYS_IMPORT_FULL_01": u2/******** dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "U3"."FAMILY" 5.984 KB 2 rows
Job "U2"."SYS_IMPORT_FULL_01" successfully completed at 13:39:37
#导入导出,要新建相应的表空间和用户shemas
#表的追加
[oracle@host2 ~]$ impdp u2/tiger dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=append
#表的替换
[oracle@host2 ~]$ impdp u2/tiger dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=replace;
Import: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:44:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "U2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2"."SYS_IMPORT_FULL_01": u2/******** dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=replace
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "U3"."FAMILY" 5.984 KB 2 rows
Job "U2"."