修改pdb名称

1、登录数据库，查看当前pdb的名称

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
12 DCNT01 READ WRITE NO

 

2、关闭pdb
SQL> alter pluggable database dcnt01 close;

Pluggable database altered.

 

3、打开pdb为限制模式

SQL> alter pluggable database dcnt01 open restricted;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
12 DCNT01 READ WRITE YES

 

4、登录pdb

SQL> alter session set container=dcnt01;

Session altered.

 

5、修改名称

SQL> alter pluggable database rename global_name to t_dcnt01;

Pluggable database altered.

 

6、重启pdb

SQL> alter pluggable database close immediate;

Pluggable database altered.

SQL> alter pluggable database open;

Pluggable database altered.

 

7、验证

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
12 T_DCNT01 READ WRITE NO