CHANGING PDB MODE

CHANGING PDB MODE

RESTRICTED MODE

SQL> CONNECT SYS@PDB1 AS SYSDBA

SQL> ALTER DATABASE CLOSE;

SQL> ALTER DATABASE OPEN RESTRICTED;

READ ONLY MODE

SQL>  CONNECT / AS SYSDBA

SQL> ALTER PLUGGABLE DATABASE ALL OPEN READ ONLY;

READ WRITE:

SELECT NAME,OPEN_MODE FROM V$PDBS;