Tuesday, June 8, 2010

Compatible Parameter

Oracle database contains compatible parameter which is of type string.
This parameter should be in same with the database version in order for the database to have the features of that version.

Generally this parameter should be checked after the database upgradation.

This information can be retrieved from the parameter file
SELECT name, value, description FROM v$parameter WHERE name = 'compatible';
or
show parameter compatible

No comments: