12cR1 PDB只读与读写转换
发布时间:2020-12-12 14:03:36 所属栏目:百科 来源:网络整理
导读: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---------- ------------------------------ ---------- ----------
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> (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |