自定义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 @ 2023-06-10 12:24  捌玖  阅读(18)  评论(0编辑  收藏  举报