Oracle 12C -- 删除PDB

最新推荐文章于 2023-12-19 09:32:07 发布

weixin_33974433

最新推荐文章于 2023-12-19 09:32:07 发布

阅读量265

点赞数

文章标签：数据库

删除PDB
SQL> select con_id,pdb_name,status from cdb_pdbs;                                          

    CON_ID PDB_NAME                       STATUS
---------- ------------------------------ ---------
         3 PDB1                           NORMAL
         2 PDB$SEED                       NORMAL
         4 P4                             NORMAL
         5 PDB_TEST                       NORMAL

SQL> select con_id,dbid,name,open_mode from v$pdbs;

    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
         2 1258043702 PDB$SEED                       READ ONLY
         3 3749525766 PDB1                           READ ONLY
         4 2192587015 P4                             READ ONLY
         5  255759235 PDB_TEST                       READ WRITE

SQL> alter pluggable database pdb_test close;

Pluggable database altered.

SQL> drop pluggable database pdb_test ;    
drop pluggable database pdb_test
*
ERROR at line 1:
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

SQL> drop pluggable database pdb_test including datafiles;

Pluggable database dropped.

SQL> select con_id,pdb_name,status from cdb_pdbs;

    CON_ID PDB_NAME                       STATUS
---------- ------------------------------ ---------
         3 PDB1                           NORMAL
         2 PDB$SEED                       NORMAL
         4 P4                             NORMAL

SQL>