Tuesday, April 29, 2025

How to check and list pluggable database in oracle ?

 


SQL> 

SQL> select name from v$pdbs;


NAME

--------------------

PDB$SEED

PDB


SQL> 




SQL> select pdb_name from cdb_pdbs;


PDB_NAME

--------------------

PDB

PDB$SEED





SQL> 

SQL> show pdbs


    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 PDB   READ WRITE NO

SQL> 

SQL> 



No comments:

Post a Comment

what is catcon.pl (Catalog Container Script) and why very useful for Oracle Multitenant Database ?

  catcon.pl (Catalog Container Script) is an Oracle utility introduced with the Multitenant Architecture (CDB/PDB) to execute SQL scripts ...