多表空间多数据文件传输,

307679393

一、数据库版本

1. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
   
2. PL/SQL Release 10.2.0.4.0 - Production
   
3. CORE    10.2.0.4.0      Production
   
4. TNS for Linux: Version 10.2.0.4.0 - Production
   
5. NLSRTL Version 10.2.0.4.0 - Production
   

复制代码

二、步骤
说明：同版本，相同字符集，相同的操作系统,导出库SID：hhps,导入库的SID：dbhhps
源数据库文件路径
/u01/app/oracle/oradata/hhps/index01.dbf
/u01/app/oracle/oradata/hhps/index02.dbf
/u01/app/oracle/oradata/hhps/user01.dbf
目的数据文件路径
/u01/app/oracle/oradata/dbhhps/datafile/index01.dbf
/u01/app/oracle/oradata/dbhhps/datafile/index02.dbf
/u01/app/oracle/oradata/dbhhps/datafile/user01.dbf

1. execute sys.dbms_tts.transport_set_check('users,index',true);
   
2. select * from sys.transport_set_violations;
   
3. alter tablespace users read only;
   
4. alter tablespace index read only;
   
5. create direcotry dmp_dir as /u01/dump';
   
6. grant read ,write on directory dump_dir to gfc;
   
7. grant read,write on directory dump_dir to hq;
   
8. 
   
9. expdp system/123456@hhps dirctory=dump_dir dumpfile=transpofrt.dmp transport_tablespaces=users,index
   
10. 
    

复制代码

复制文件到目标机器

创建用户

1. create direcotry dump_dir as /u01/dump';
   
2. grant read,write on directory dump_dir to hq;
   
3. grant read,write on directory dump_dir to gfc;
   
4. impdp system/future@dbhhps directory=dump_dir dumpfile=transport.dmp  transport_datafiles='index01.dbf','index02.dbf','user01.dbf' remap_datafile='/u01/app/oracle/oradata/hhps/index01.dbf':'/u01/app/oracle/oradata/DBHHPS/datafile/index01.dbf','/u01/app/oracle/oradata/hhps/oradata/index02.dbf':'/u01/app/oracle/oradata/DBHHPS/oradata/index02.dbf','/u01/app/oracle/oradata/hhps/use01.dbf':'/u01/app/oracle/oradata/DBHHPS/datafile/user01.dbf' remap_schema=hq:hq,gfc:gfc
   
5. 
   

复制代码

三、结果

1. Import> status
   
2. 
   
3. Job: SYS_IMPORT_TRANSPORTABLE_01
   
4.   Operation: IMPORT                        
   
5.   Mode: TRANSPORTABLE                  
   
6.   State: EXECUTING                     
   
7.   Bytes Processed: 0
   
8.   Current Parallelism: 1
   
9.   Job Error Count: 0
   
10.   Dump File: /u01/dump/transport.dmp
    
11.   
    
12. Worker 1 Status:
    
13.   State: EXECUTING   

复制代码

不报错也不显示完成，查看数据库没有相关对象

Maclean Liu(刘相兵

这个持续了多久？　可以对impdp 做个10046 或者 expdp trace看下实际情况

307679393

持续三小时，后中止了，数据库不大