Shulou(Shulou.com)06/01 Report--

PDB read-only and read-write conversion

1. Pdb to mount status SQL > alter pluggable database pdb11 close immediate;Pluggable database altered.2, view pdbSQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED--2 PDB$SEED READ ONLY NO 3 PDB11 MOUNTEDSQL > 3, Pdb read-only SQL > SQL > alter pluggable database pdb11 open read only Pluggable database altered.SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB11 READ ONLY NOSQL > alter pluggable database pdb11 close immediate Pluggable database altered.4, pdb read and write SQL > alter pluggable database pdb11 open read write;Pluggable database altered.SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB11 READ WRITE NOSQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.