transport tablespace Tips

注意字符集什么的，OS版本，是否加密什么的，这里不列了。列下被坑到的几个点。

1.高版本到低版本（测试使用的11.2.0.2->10.2.0.5）有BUG（Bug 10297446），用不了。

2.You cannot transport the SYSTEM tablespace. Therefore, objects such as sequences, PL/SQL packages, and other objects that depend on the SYSTEM tablespace are not transported. You must either create these objects manually on the destination database, or use Data Pump to transport the objects that are not moved by transportable tablespace. SYSTEM表空间不能用TRANSPORT TABLESPACE导，基本上就说明希望用TRANSPORT TABLESPACE的方式对整个DB做迁移的想法难度比较 大。

查了下SUPPORT文档。

• Create an "empty" database in the new environment
• Plug in all data tablespaces from source to target database
• SYSTEM+SYSAUX tablespaces can't be transported
• Additional steps necessary to move views, synonyms etc.
• Possibly very fast upgrade
• Complexity could be constraining
• Works cross-platform and cross-Endianness since Oracle Database 10g

果然是不好弄。

3. 11GR1之后，用TRANSPORT TABLESPACE必须要使用DATA PUMP。

4.10.2.0.5->11.2.0.2，低到高是Ok的。

Job "TESTER1"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Mon Mar 3 16:11:07 2014 elapsed 0 00:00:02