自定义pdb$seed

https://www.codenong.com/cs109161181/

00:02:26 SQL> alter session set "_oracle_script"=true;

Session altered.

Elapsed: 00:00:00.01
00:04:36 SQL> alter pluggable database pdb$seed close immediate instances=all;

Pluggable database altered.

Elapsed: 00:00:01.11
00:04:54 SQL> alter pluggable database pdb$seed open read write instances=all;

Pluggable database altered.

Elapsed: 00:00:02.71
00:05:11 SQL> select inst_id,open_mode,name from gv$pdbs where name='PDB$SEED';

   INST_ID OPEN_MODE  NAME
---------- ---------- --------------------
     1 READ WRITE PDB$SEED
     2 READ WRITE PDB$SEED

Elapsed: 00:00:00.01
00:05:30 SQL> alter session set container=pdb$seed;

Session altered.

Elapsed: 00:00:00.04


00:10:22 SQL> create user pdbadmin identified by vault1;

User created.

Elapsed: 00:00:00.09

00:13:14 SQL> alter pluggable database close immediate instances=all;

Pluggable database altered.

Elapsed: 00:00:01.22
00:13:27 SQL> alter pluggable database open read only instances=all;

Pluggable database altered.

Elapsed: 00:00:01.60

00:13:47 SQL> alter session set "_oracle_script"=false ;

Session altered.

Elapsed: 00:00:00.01

posted @   捌玖  阅读(29)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 从HTTP原因短语缺失研究HTTP/2和HTTP/3的设计差异
· 三行代码完成国际化适配,妙~啊~
点击右上角即可分享
微信分享提示