Check currently connected PDB name in Multitenant

Check the currently connected PDB in SQLPLUS session

SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT

SQL> show con_id
CON_ID
------------------------------
1

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
CON_NAME
------------------------------
PDB1

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.