9i升级到11g，请问如何实现？

[全栈极简]

为了达到方便清理表空间的目的，delete操作后执行shrink命令回收表空间，特地从9i升级到11g，有做过这方面的专家吗？要注意点什么？

[碧水幽幽泉]

9i升级到11g? 没弄过！
建议从9i升级到11g，然后10g升级到11g！

[duyu1025]

没搞过，帮你up

[Dave]

没有升级过，官网的操作步骤如下：

The path that you must take to upgrade to the new Oracle Database 11g release depends on the release number of your current database. It might not be possible to directly upgrade from your current release of Oracle Database to the latest release. Depending on your current release, you might be required to upgrade through one or more intermediate releases to upgrade to the new Oracle Database 11g release.

For example, if the current database is running release 8.1.6, then follow these steps:

1.Upgrade release 8.1.6 to release 8.1.7.4 using the instructions in Oracle8i Migration Release 3 (8.1.7).

2.Upgrade release 8.1.7.4 to release 10.2.0.4 using the instructions in Oracle Database Upgrade Guide Release 2 (10.2).

3.Upgrade release 10.2.0.4 to the new Oracle Database 11g release using the instructions in this guide.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10819/preup.htm#i1007718



------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(满); DBA2 群：62697977
DBA3 群：63306533; 聊天 群：40132017

[Dave]

•7.3.3 (or lower) -> 7.3.4 -> 9.2.0.8 -> 11.2

•8.0.5 (or lower) -> 8.0.6 -> 9.2.0.8 -> 11.2

•8.1.7 (or lower) -> 8.1.7.4 -> 10.2.0.4 -> 11.2

•9.0.1.3 (or lower) -> 9.0.1.4 -> 10.2.0.4 -> 11.2