文档解释
ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher
Cause: An add/drop column operation for compressed table has been performed on the database. This requires COMPATIBLE to be set to 10.0.0.0.0 or higher during upgrade from 9.2 to a 10i or higher release.
Action: Set COMPATIBLE to 10.0.0.0.0 and retry the upgrade.
ORA-39727: COMPATIBLE参数必须设置成 10.0.0.0.0 或以上
错误说明:系统将以前的模式用于较新功能时会触发此错误,如创建函数时要求 COMPATIBLE 必须高于 10.0.0.0.0。
常见案例
解决方法:要解决 ORA-39727 错误,可以重新设置 COMPATIBLE 参数,并把其值设置高于 10.0.0.0.0。可以使用以下 SQL 来查看当前 COMPATIBLE 参数的值,并重新设置它以解决 ORA-39727:
ALTER SYSTEM SET COMPATIBLE=10.1.0.0.0 SCOPE=SPFILE;
重新启动数据库,COMPATIBLE 将更改为新值,这样 ORA-39727 错误就可以被解决。