transport tablespace Tips

来源：互联网发布：链接下载软件编辑：程序博客网时间：2024/04/28 19:47

注意字符集什么的，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

0 0