Getting oriented in a CDB when all you have is SQL*Plus access…

SQL> col PDB_NAME FOR A15
 
SQL> SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
 
    PDB_ID PDB_NAME	   STATUS
---------- --------------- ---------
	 2 PDB$SEED	   NORMAL
	 3 ORCL 	   NORMAL
 
SQL> ALTER SESSION SET container=orcl;
 
SESSION altered.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.