修改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