Init parameterCompatibility

ENABLE_PLUGGABLE_DATABASE

What it controls

Whether the database is a multitenant container database.

Know this before you change it

Set when the CDB is created. It's not something to change on a running database.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'enable_pluggable_database';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'enable_pluggable_database' AND isspecified = 'TRUE';8 9-- Static: saved in the spfile, takes effect after a restart10ALTER SYSTEM SET enable_pluggable_database = TRUE SCOPE = SPFILE SID = '*';

Related scripts

• Pluggable databases and their stateEvery PDB with its open mode, whether it's restricted, when it opened and its size. RESTRICTED = YES usually means a plug-in violation.

Open in the parameter referenceOracle's reference

More in Compatibility

• COMPATIBLEThe release whose on-disk format and features the database uses.
• NLS_LENGTH_SEMANTICSWhether VARCHAR2 lengths in new columns default to bytes or characters.