导航：首页 > 数据库 >

12cR1 PDB只读与读写转换

发表于：2024-11-29 作者：千家信息网编辑

千家信息网最后更新 2024年11月29日，PDB只读与读写转换1、pdb 到mount状态SQL> alter pluggable database pdb11 close immediate;Pluggable database alter

千家信息网最后更新 2024年11月29日12cR1 PDB只读与读写转换

PDB只读与读写转换

1、pdb 到mount状态SQL> alter pluggable database pdb11 close immediate;Pluggable database altered.2、查看pdbSQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 PDB11                          MOUNTEDSQL> 3、pdb只读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读写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>

很赞哦！