Values for the COMPATIBLE Initialization Parameter in Oracle Database
Review to find the default, minimum, and maximum values for the COMPATIBLE initialization parameter.
The following table lists the default, minimum, and maximum values for COMPATIBLE in Oracle Database 18c, and in each release supported for upgrading to Oracle Database 18c:
Table 7-1 The COMPATIBLE Initialization Parameter
| Oracle Database Release | Default Value | Minimum Value | Maximum Value |
|---|---|---|---|
| Oracle Database 18c |
|
|
With each Quarterly Release Update (Update) or Release Update Revision (Revision), the maximum value increment increases to the most recent update or revision. For 18c Update 1 Revision 1, the increment is 18.1.1. For 18c Update 3, at the time of its initial release, the maximum value is 18.3.0. |
|
Oracle Database 12c Release 2 (12.2) |
|
|
|
|
Oracle Database 12c Release 1 (12.1) |
|
|
|
|
Oracle Database 11g Release 2 (11.2) |
|
|
|
Parent topic: Checking Compatibility Before Upgrading Oracle Database