ITPub博客

首页 > 应用开发 > IT综合 > 参数compatible的不可逆性

参数compatible的不可逆性

原创 IT综合 作者:zhyuh 时间:2006-02-28 16:35:07 0 删除 编辑
Oracle10g中,设置compatible参数时,其值不能比上一个值小,以保证Oracle10g不向下兼容,只能向上兼容。[@more@]

详细解释如下:
For example, let's say you set the COMPATIBLE parameter to 10.0.0 on the Initialization Parameters page in Enterprise Manager (EM), and start the database. If you then shut down the database and restart with the COMPATIBLE parameter set to 9.2.0, an error displays during startup informing you that the compatible setting cannot be reversed.

A problem arises if you set the COMPATIBLE parameter to a value higher than the existing one. In so doing, you advance the compatibility of your database, and you won't be able to start the database using the true, lower-compatibility level setting. The only way out of this is to perform a recovery of an older instance of the database, before the COMPATIBLE parameter was changed, but any other changes you may have made to the database will also be lost. For this reason, the ALTER DATABASE RESET COMPATIBILITY command no longer works in Oracle Database 10g.

这么设置有什么好处?不懂

反正下次如果要改变这个参数时,一定要考虑到这些。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/207/viewspace-817485/,如需转载,请注明出处,否则将追究法律责任。

上一篇: sql*plus参数传递
下一篇: utl_mail package
请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2012724