Oracle 12C -- 删除PDB

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

    CON_ID PDB_NAME                       STATUS
---------- ------------------------------ ---------
          PDB1                           NORMAL
          PDB$SEED                       NORMAL
          P4                             NORMAL
          PDB_TEST                       NORMAL

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

    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
           PDB$SEED                       READ ONLY
           PDB1                           READ ONLY
           P4                             READ ONLY
            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 :
ORA-: 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
---------- ------------------------------ ---------
          PDB1                           NORMAL
          PDB$SEED                       NORMAL
          P4                             NORMAL

SQL>