What is a non-CDB database?

Question

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'. 28 янв. 2015 г.

What is a non CDB Oracle database?

A pluggable database (PDB) is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. PDBs can be plugged into CDBs. A CDB can contain multiple 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 non container database?

1. Non CDB is similar database present in old oracle version like 11g ,10g ,9i etc. 2. CDB is further divided into container like Root container, PDB Seed , PDB user databases but in NON CDB only one database.

How do I know if my database is PDB or CDB?

Starting Oracle 12.2 sys_context('USERENV','DB_NAME') will show the name of the Database in CDB$ROOT and the name of the PDB inside the PDB.

Expert · Answer