传输表空间大版本号到小版本号

saup007

遇到的问题与此博客内容一致：

http://www.icloudstack.com/archives/67.html

环境：

源：

32位linnux oracle 10.2.0.5

目标：

64位linux oracle 10.2.0.4

创建用户ttt，并授权sysdba权限

导出

$ expdp ttt/ttt directory=dir_expdp dumpfile=tsb_erating_xuanyuan.dmp transport_tablespaces=ERATING_XUANYUAN_LOG01,ERATING_XUANYUAN_USER01,ERATING_XUANYUAN_INDEX01 transport_full_check=y version=10.2.0.4.0

把三个表空间数据文件拷贝到目标

$ impdp ttt/ttt DUMPFILE=tsb_erating_xuanyuan.dmp logfile=tsb_xuanyuan.log DIRECTORY=dir_expdp TRANSPORT_DATAFILES=/u01/oradata/YTSTD2/datafile/erating_xuanyuan_user01.dbf,/u01/oradata/YTSTD2/datafile/erating_xuanyuan_index01.dbf,/u01/oradata/YTSTD2/datafile/erating_xuanyuan_log01.dbf version=10.2.0.4.0

Import: Release 10.2.0.4.0 - 64bit Production on Monday, 08 April, 2013 15:38:08

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "TTT"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "TTT"."SYS_IMPORT_TRANSPORTABLE_01":  ttt/******** DUMPFILE=tsb_erating_xuanyuan.dmp logfile=tsb_xuanyuan.log DIRECTORY=dir_expdp TRANSPORT_DATAFILES=/u01/oradata/YTSTD2/datafile/erating_xuanyuan_user01.dbf,/u01/oradata/YTSTD2/datafile/erating_xuanyuan_index01.dbf,/u01/oradata/YTSTD2/datafile/erating_xuanyuan_log01.dbf version=10.2.0.4.0
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-00721: changes by release 10.2.0.5.0 cannot be used by release 10.2.0.4.0

Job "TTT"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 15:38:16

在网上上MOS上没有找到解决方法，修改数据库参数应该不可行。

psufnxk2000

用  exp 试试。