12cR1PDB只读与读写转换
PDB只读与读写转换
网站建设哪家好,找成都创新互联公司!专注于网页设计、网站建设、微信开发、重庆小程序开发公司、集团企业网站建设等服务项目。为回馈新老客户创新互联还提供了铜鼓免费建站欢迎大家使用!
1、pdb 到mount状态
SQL> alter pluggable database pdb11 close immediate;
Pluggable database altered.
2、查看pdb
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB11 MOUNTED
SQL>
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 NO
SQL> 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 NO
SQL>
本文标题:12cR1PDB只读与读写转换
文章路径:http://myzitong.com/article/ppdcos.html