Saturday, May 3, 2025

How to open pluggable database in read write mode ?

 open pluggable database in read write mode

SQL>

SQL>

SQL>

SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 DEMOPDB1                       MOUNTED

SQL>




SQL> alter pluggable database demopdb1 open read write;


Pluggable database altered.


SQL>


SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 DEMOPDB1                       READ WRITE NO

SQL>


No comments:

Post a Comment