Export: Release 10.2.0.5.0 - 64bit Production on Sunday, 01 January, 2012 22:44:51
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, OLAP, Data Mining and Real Application Testing options Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": "sys/******** AS SYSDBA" directory=expdp_dir2
dumpfile=source2.dmp logfile=source2.log transport_tablespaces=exp_rac1,exp_rac1_index Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK Processing object type TRANSPORTABLE_EXPORT/TABLE Processing object type TRANSPORTABLE_EXPORT/INDEX Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK Master table "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is: /home/oracle/expdp_dir2/source2.dmp Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 22:45:12
[oracle@server49 ~]$ ls /home/oracle/expdp_dir2/ exp_rac1_01.dbf exp_rac1_index_01.dbf source2.dmp source2.log
四:在目标数据库上创建用户和目录对象,并利用rman将表空间的数据文件导入到asm实例上
[oracle@rac1 ~]$ sqlplus sys/123456@racdb1 as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Sun Jan 1 23:13:17 2012 Copyright (c) 1982, 2010, 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
SQL> create user test2 identified by oracle account unlock; User created.
SQL> grant connect,resource to test2; Grant succeeded.
SQL> create directory expdp_dir2 as '/home/oracle/expdp_dir2'; Directory created.
SQL> grant read,write on directory expdp_dir2 to test2; Grant succeeded.
RMAN> convert datafile '/home/oracle/expdp_dir2/exp_rac1_01.dbf' format '+DATA/racdb/datafile/exp_rac1_01.dbf';
Import: Release 10.2.0.5.0 - 64bit Production on Monday, 02 January, 2012 0:08:33 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 "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": "sys/******** AS SYSDBA" directory=expdp_dir2
+DATA/racdb/datafile/exp_rac1_index_01.dbf Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK Processing object type TRANSPORTABLE_EXPORT/TABLE Processing object type TRANSPORTABLE_EXPORT/INDEX Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 00:08:52
六:测试
[oracle@rac1 ~]$ sqlplus sys/123456@racdb as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jan 2 00:09:20 2012 Copyright (c) 1982, 2010, 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
SQL> select count(*) from test2.source2;
COUNT(*) ---------- 1181964
SQL> col table_name format a20 SQL> col tablespace_name format a20 SQL> select table_name,tablespace_name from dba_indexes 2 where owner='TEST2' and index_name='I_SOURCE2';