expdp/impdp transport_tablespace

expdp/impdp transport_tablespace[@more@]

[oracle@primary ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 18 13:07:45 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter tablespace wlcsp read only;

Tablespace altered.

[oracle@primary ~]$ expdp system/wlcsp123 directory=temp_dir dumpfile=wlcsp.dmp transport_tablespaces=wlcsp transport_full_check=y

Export: Release 11.2.0.1.0 - Production on Mon Nov 18 13:08:24 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** directory=temp_dir dumpfile=wlcsp.dmp transport_tablespaces=wlcsp transport_full_check=y
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/COMMENT
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
/opt/wlcsp.dmp
******************************************************************************
Datafiles required for transportable tablespace WLCSP:
/u01/oradata/wlcsp/wlcsp_data01.dbf
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 13:09:04

上面是源端的操作
操作完了之后，就dmp文件和datafile文件 copy到目标端的相应位置
######################################################################################################
目标端操作:
C:>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 18 13:10:01 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user test identified by test;

用户已创建。

SQL> grant connect,resource to test;

授权成功。

SQL> grant read,write on directory temp_dir to test;

授权成功。

C:>impdp system/oracle dumpfile=wlcsp.dmp directory=temp_dir transport_datafile
s=c:oracle11goradataorclwlcsp_data01.dbf remap_schema=wlcsp:test,wlcsp_1:tes
t1

Import: Release 11.2.0.1.0 - Production on 星期一 11月 18 13:17:28 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01"
启动 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** dumpfile=wlcsp.dmp
directory=temp_dir transport_datafiles=c:oracle11goradataorclwlcsp_data01.d
bf remap_schema=wlcsp:test,wlcsp_1:test1
处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
处理对象类型 TRANSPORTABLE_EXPORT/TABLE
处理对象类型 TRANSPORTABLE_EXPORT/INDEX
处理对象类型 TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
处理对象类型 TRANSPORTABLE_EXPORT/INDEX_STATISTICS
处理对象类型 TRANSPORTABLE_EXPORT/COMMENT
处理对象类型 TRANSPORTABLE_EXPORT/TABLE_STATISTICS
处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
作业 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" 已于 13:17:55 成功完成

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1061048/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1061048/