Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

DBA - Container Database

Back

• DBA - Container Database
  • List all container
  • Create CBD
  • Default Tablespaces in the Multitenant Architecture

---

List all container

• View:

  • V$CONTAINERS

• lists all containers in the CDB:

  • SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;

---

Create CBD

• Syntax:

---

Default Tablespaces in the Multitenant Architecture

Tablespace	Root	PDB
SYSTEM	Oracle-supplied metadata;	user metadata.
SYSAUX	exists	exists in each
TEMP	a single default temporary tbsp for all PDB.	Can create tbsp for pdb
UNDO	one active	local in each (recommended)
USERS	one	Each

---

TOP