|Oracle® Database Reference
12c Release 1 (12.1)
|PDF · Mobi · ePub|
|Range of values||
NONCDB_COMPATIBLE enables you to get behavior similar to a non-CDB when issuing SQL commands inside a PDB in a CDB.
Set this parameter if you are using a single PDB in your CDB configuration and you have legacy code that causes
ORA-65040 when you run it in the PDB.
Indicates the behavior for SQL statements will be like a non-CDB although the statements are issued in a PDB in a CDB.
Indicates the behavior will for SQL statements will be like a CDB. This is the default value of the parameter.
There are some statements (such as
ALTER DB BACKUP CONTROLFILE) which can be issued in a non-CDB, but in a CDB they must be issued in the root (because they affect the whole CDB) and would result in an error if issued in a PDB.
ALTER DATABASE or
ALTER SYSTEM statements are not permitted inside a PDB, and they will fail if
NONCDB_COMPATIBLE=FALSE is set in
init.ora. However, these statements will succeed if
NONCDB_COMPATIBLE=TRUE is set.