代码改变世界

Oracle 12C -- 删除PDB

2015-10-31 14:59  abce  阅读(2591)  评论(0)  编辑  收藏  举报 
删除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>