if you create an Oracle Database 11gRelease 2 (11.2) database, but specify COMPATIBLE=10.0.0 in the initialization parameter file, then features that require 11.2 compatibility generate an error if you try to use them. Such a database is...
For example, if you create an Oracle Database 10g database, but specify COMPATIBLE = 9.2.0.2 in the initialization parameter file, then features that requires 10.0 compatibility will generate an error if you try to use them. Such a database is said to be at the 9.2.0.2 compatibility level...
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 compatib...
Note:For Oracle Database 10g Release 2 (10.2), the default value of the COMPATIBLE parameter is 10.2.0. The minimum value is 9.2.0. If you create an Oracle Database using the default value, you can immediately use all the new features in this release, andyou can never downgrade the da...
详解Oracle升高或降低参数Compatible 今天在看oracle 10g的文档,注意到Irreversible Compatibility这个说法。 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 ...
COMPATIBLEenables you to use a new release of Oracle while ensuring the ability to downgrade the database to an earlier release. PropertyDescription Parameter type String Syntax COMPATIBLE =release_number Default value 12.2.0 Modifiable No Modifiable in a PDB ...
For details, see GUC Parameter Usage. Table 1 GUC parameters of GaussDB (Oracle-compatible mode) Oracle-Compatible Configuration Item Compatibility Configuration Item Name Supported Database Enable Description behavior_compat_options display_leading_zero Specifies how floating point numbers are displayed....
Oracle Databaseのリリースデフォルト値最小値最大値 Oracle Database 18c 18.0.0 11.2.0 CDBまたは非CDBインスタンスの場合、RUまたはRURのCOMPATIBLEパラメータを変更しないでください。 Oracle Database 12cリリース2 (12.2) 12.2.0 11.2.0 12.2.0 Oracle Database 12c リリース1(...
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later: ORA-00406 COMPATIBLE parameter needs to be 12.0.0.0.0 or greater while creating table with XMLTYPE
ORA-00401:the value for parameter compatible is not supported by this release这个提示的ORACLE的什么错误?下面是初始化参数文件 db_name=WXLDBinstance_name=WXLDBdb_domain=wxl.bj.cndb_cache_size=12Mlog_buffer=60000000shared_pool_size=6