Saturday, May 24, 2025

How to check and open pluggable database ?

 SQL>

SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            MOUNTED

         4 DEMO1                          MOUNTED

SQL> alter pluggable database demo1 open read write ;


Pluggable database altered.


SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            MOUNTED

         4 DEMO1                          READ WRITE NO

SQL>

No comments:

Post a Comment

Key Differences & 19c Best Practices (AMM and ASMM)

Key Differences between  AMM and ASMM  & 19c Best Practices AMM (Automatic Memory Management) -  (MEMORY_TARGET): How it works: Oracle a...