重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12c 删除某个 pdb [打印本页]

作者: 郑全 时间: 2019-2-10 00:03
标题: oracle 12c 删除某个 pdb
比如我们要删除 pdb hr
1.查看目前有哪些 pdb

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         READ WRITE NO
      5 HR                            READ WRITE NO

2.关闭 hr pdb

SQL> alter pluggable database hr close;
Pluggable database altered.

3.删除 hr pdb

SQL> drop pluggable database hr including datafiles;
Pluggable database dropped.

4.验证hr pdb已经被删除

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         READ WRITE NO

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)