如题，不是说PDB$SEED只能是 READ ONLY状态吗
下面SQL运行时已经在PDB$SEED这一层了，之前运行了aleter session set container=PDB$SEED
SQL> shu normal;
Pluggable Database closed.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
SQL> startup;
Pluggable Database opened.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
使用这个参数是有风险的，如果可以的话你看下这两篇文章
https://www.anbob.com/archives/5149.html
https://mikedietrichde.com/2020/02/10/be-aware-when-you-use-_oracle_script-in-scripts/
评论
有用 0
pdb$seed种子库，默认打开模式为read only
如果要修改pdb$seed的状态，则需在当前会话修改"_oracle_scripts"为true
- SQL> alter session set "_oracle_script"=true;
- Session altered.
- SQL> alter pluggable database pdb$seed close immediate;
- Pluggable database altered.
- SQL> alter pluggable database pdb$seed open;
- Pluggable database altered.
- SQL> show pdbs
- CON_ID CON_NAME OPEN MODE RESTRICTED
- ---------- ------------------------------ ---------- ----------
- 2 PDB$SEED READ WRITE NO
- 3 PDB1 MOUNTED
评论 有用 2pdb$seed可以是open状态，但是建议你不要在pdb$seed中写入数据，它就是个模板，当你通过pdb$seed模板创建新的pdb时，数据会继承到新的pdb，有这个需求还可以，没有这个需求的话会造成数据泄露的风险
评论 有用 0似乎和那个隐含参数无关，在PDB$SEED下将该参数设为FALSE，不是也可以吗：
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
SQL> alter session set "_oracle_script"=false;
Session altered.
Elapsed: 00:00:00.00
SQL> shut immedate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
Pluggable Database closed.
SQL> startup;
Pluggable Database opened.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
评论 有用 0
