How do I know if a database is a container database?

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

CDB > PDB > CDB As you can see, you get informations about a PDB$SEED in the Container Database. The SEED Database is used as a draft in the multitenant environment for creating new PDB's. In a PDB you will always get only one result in every case, your current PDB.

What are container databases?

Container Database (CDB): This is the database that is created when that database supports Oracle's multitenant option. It's also called the ROOT container and is the CDB$ROOT within the data dictionary views of the CDB. Root Container Database: This is created automatically when you create a multitenant database.

What is the difference between container and non container database?

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 non-CDB database?

A non-CDB is anything that isn't a CDB; that is, any database before 12c, or a 12c database created without the enable pluggable database clause. If you create a non-CDB it isn't Multitentant and is a single-instance standalone like a pre-12c database.