What is a non CDB Oracle database?

What is Oracle non CDB?

Basically: A non-CDB stores all metadata (system ones and user ones) in the same dictionary. A CDB stores user metadata only in the database dictionary, which have links to a common dictionary that contains the system metadata. The common container is called 'root' and the database is called 'pluggable database'.

What is a CDB in Oracle?

The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB). A CDB includes zero, one, or many customer-created pluggable databases (PDBs).

How do I know if my database is non CDB?

You can query the CDB column in the V$DATABASE view to see if a database is CDB. If the current database is CDB, the column value will be YES, otherwise the CDB column value will be NO.

What is the difference between CDB and PDB in Oracle?

A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a non-CDB . All Oracle databases before Oracle Database 12c were non-CDBs.