4)最后检查COMPATIBLE是否已经被正确设置: SELECT name, value FROM v$parameter WHERE name = ‘compatible’; 官方英文解释 COMPATIBLEenables you to use a new release of Oracle while ensuring the ability to downgrade the database to
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...
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...
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 ...
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 ...
Action:Specify a valid release value for the queue table compatible parameter 。 ORA-25332: Invalid release value string for queue table compatible parameter是Oracle的一个错误码,用于提示用户在重新创建队列表时参数输入不正确。当你试图转换队列表在不同版本的Oracle上,可能会遇到这个错误,例如要从10g转换到...
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...
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....
For two types to be parameter-compatible, the types must be compatible after the top-level qualifiers, if any, have been removed, and after a function or array type has been converted to the appropriate pointer type. 6.12.7 Special Cases signed int behaves the same as int, except possibly...
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