PDB重命名

最新推荐文章于 2023-12-05 10:35:42 发布

weixin_34381666

最新推荐文章于 2023-12-05 10:35:42 发布

阅读量383

点赞数

文章标签：数据库 python

原文链接：http://www.cnblogs.com/wangchaoyuana/p/7531993.html

版权

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>

转载于:https://www.cnblogs.com/wangchaoyuana/p/7531993.html