oracle compatible参数详解
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 10g database, but specify COMPATIBLE = 9.2.0.2 in the initialization parameter file, then features that requires 10.0 compatibility will generate an error if you try to use them. Such a database is said to be at the 9.2.0.2 compatibility level. You can advance the compatibility level of your database. If you do advance the compatibility of your database with the COMPATIBLE initialization parameter, 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> Note:For Oracle Database 10g> SQL>show parameter compatible;SQL>ALTER SYSTEM SET compatible='10.1.0.2.0' SCOPE=SPFILE;
页:
[1]