My Oracle Support Banner

COMPATIBLE Parameter - Explanation, Usage and Advise (Doc ID 1458741.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


This bulletin is intended to clarify the use of the basic initialization parameter COMPATIBLE.
Setting the COMPATIBLE parameter correctly is essential for enabling some new features.
However, not increasing the COMPATIBLE parameter too soon may be even more essential to avoid problems.


The information is intended for DBA's for enabling some specific new features especially after performed upgrades.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.