How the COMPATIBLE Initialization Parameter Operates in Oracle Database
The
COMPATIBLE initialization parameter enables or disables Oracle Database features based on release compatibility
The
COMPATIBLE initialization parameter operates in the following way:- The
COMPATIBLEinitialization parameter enables or disables the use of features, to help protect your existing application use of data.If you run an Oracle Database 12c database with theCOMPATIBLEinitialization parameter set to11.2.0, then the database software generates database structures on disk that are compatible with Oracle Database Release 11g release 2 (11.2). If you try to use features that are part of a later release of Oracle Database, and make the database incompatible with theCOMPATIBLEinitialization parameter, then an error occurs. However, new features are enabled that do not create changes on disk that are incompatible with Oracle Database Release 11g release 2. - If you make changes to the database that make the database incompatible with the
COMPATIBLEinitialization parameter setting you want to use, then the database does not start, and initialization terminates in an error. If this happens, then you must set theCOMPATIBLEinitialization parameter to an appropriate value for the database.
Source- https://docs.oracle.com
No comments:
Post a Comment