Oracle DBA, How To, Error, Cause and Action

To Find The Pluggable Databases

To find PDB within CDB, we can query v$pdbs, in this example I have 1 PDB namely QUOTE

SQL> select con_id, name, open_mode from v$pdbs;
CON_ID     NAME                        OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED                     READ ONLY
3 QUOTE MOUNTED

No comments:

Post a Comment

Thanks for your comment.