Check currently connected PDB name in Multitenant

Check the currently connected PDB in SQLPLUS session

SQL> show con_name

SQL> show con_id

Change the currently connected database in Multitenant

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         4 PDB1                           READ WRITE NO
         5 PDB2                           READ WRITE NO

SQL> alter session set container=PDB1;
Session altered.

SQL> show con_name

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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