Oracle数据库中有个参数COMPATIBLE，我们有时候会叫它为编译版本。
对于该参数的含义，官方文档的解释是：
COMPATIBLE allows you to use a new release of Oracle, while at the same time guaranteeing backward compatibility with an earlier release. This is helpful if it becomes necessary to revert to the earlier release.
This parameter specifies the release with which Oracle must maintain compatibility. It allows you to take advantage of the maintenance improvements of a new release immediately in your production systems without testing the new functionality in your environment. Some features of the release may be restricted.
When using a standby database, this parameter must have the same value on both the primary and standby databases.
需要注意，这个参数在Oracle 9i的时候，可以将版本往低调，但是到10g之后，只能往高调整，不能往低调。
Starting with Oracle Database 10g, the COMPATIBLE initialization parameter becomes irreversible; that is, it cannot be set to a value that is less than a previous value. Therefore, the compatibility of the database can go only forward and never backward.
For example, suppose that you set COMPATIBLE to 10.0.0 and start up the database, then shut down the database to restart with COMPATIBLE set to 9.2.0. During startup, you get an error indicating that the compatible setting cannot be reversed.
If you do advance the compatibility（的值） of your database with the COMPATIBLE initialization parameter, there is no way to start the database using a lower compatibility level setting,except by doing a point-in-time recovery to a time before compatibility was advanced. （so）Any changes since, are lost.
Consequently, the ALTER DATABASE RESET COMPATIBILITY command is now obsolete.
有时候，我们在Oracle 10.2.0.4版本的数据库中，会看到编译版本为10.2.0.1。这种情况可能是因为，该数据库是在10.2.0.1的数据库软件版本上创建的，而后数据库软件做了升级，升级之后继承了之前的编译版本。如果是在10.2.0.4数据库版本上新建的数据库，则默认其编译版本为10.2.0.3
对于该参数的含义，官方文档的解释是：
COMPATIBLE allows you to use a new release of Oracle, while at the same time guaranteeing backward compatibility with an earlier release. This is helpful if it becomes necessary to revert to the earlier release.
This parameter specifies the release with which Oracle must maintain compatibility. It allows you to take advantage of the maintenance improvements of a new release immediately in your production systems without testing the new functionality in your environment. Some features of the release may be restricted.
When using a standby database, this parameter must have the same value on both the primary and standby databases.
需要注意，这个参数在Oracle 9i的时候，可以将版本往低调，但是到10g之后，只能往高调整，不能往低调。
Starting with Oracle Database 10g, the COMPATIBLE initialization parameter becomes irreversible; that is, it cannot be set to a value that is less than a previous value. Therefore, the compatibility of the database can go only forward and never backward.
For example, suppose that you set COMPATIBLE to 10.0.0 and start up the database, then shut down the database to restart with COMPATIBLE set to 9.2.0. During startup, you get an error indicating that the compatible setting cannot be reversed.
If you do advance the compatibility（的值） of your database with the COMPATIBLE initialization parameter, there is no way to start the database using a lower compatibility level setting,except by doing a point-in-time recovery to a time before compatibility was advanced. （so）Any changes since, are lost.
Consequently, the ALTER DATABASE RESET COMPATIBILITY command is now obsolete.
有时候，我们在Oracle 10.2.0.4版本的数据库中，会看到编译版本为10.2.0.1。这种情况可能是因为，该数据库是在10.2.0.1的数据库软件版本上创建的，而后数据库软件做了升级，升级之后继承了之前的编译版本。如果是在10.2.0.4数据库版本上新建的数据库，则默认其编译版本为10.2.0.3
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23850820/viewspace-2122251/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/23850820/viewspace-2122251/
1357
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
