代码改变世界

PDB重命名

2015-06-23 21:19  abce  阅读(593)  评论(0)    收藏  举报

PDB重命名

将PDB clonedb重命名为rdb

SQL> select name,open_mode from v$pdbs;    

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
YB                             MOUNTED
YB1                            MOUNTED
CLONEDB                        READ WRITE

SQL> alter session set container=clonedb;

Session altered.

SQL> shutdown immediate;
Pluggable Database closed.

#以restrict模式打开
SQL> startup open restrict
Pluggable Database opened.
SQL> alter pluggable database clonedb rename global_name to rdb;

Pluggable database altered.

SQL> show con_name;

CON_NAME
------------------------------
RDB
SQL>