Specifying the Database Compatibility Level

The COMPATIBLE initialization parameter controls the database compatibility level.

prince2 certification training courses malaysia

• Set the COMPATIBLE initialization parameter to a release number.

• About The COMPATIBLE Initialization Parameter
  The COMPATIBLE initialization parameter enables or disables the use of features in the database that affect file format on disk. For example, if you create an Oracle Database 18c database, but specify COMPATIBLE=11.2.0 in the initialization parameter file, then features that require Oracle Database 18c compatibility generate an error if you try to use them. Such a database is said to be at the 11.2.0 compatibility level.

power bi training courses malaysia

About The COMPATIBLE Initialization Parameter

The COMPATIBLE initialization parameter enables or disables the use of features in the database that affect file format on disk. For example, if you create an Oracle Database 18c database, but specify COMPATIBLE=11.2.0 in the initialization parameter file, then features that require Oracle Database 18c compatibility generate an error if you try to use them. Such a database is said to be at the 11.2.0 compatibility level.

php programming training courses malaysia

You can advance the compatibility level of your database by changing the COMPATIBLE initialization parameter. If you do, then 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 the compatibility was advanced.

The default value for the COMPATIBLE parameter is the release number of the most recent major release.

php and MySQL training courses malaysia