All technological notes.
View:
V$CONTAINERSlists all containers in the CDB:
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
| 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 |