Determining Whether a Database is a CDB
SELECT CDB FROM V$DATABASE;
Each Container in a CDB
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
Status of Each PDB
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
CDB and PDB Queries
CDB and PDB Queries
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 4 guests