Oracle 12c Drop PDBs

https://www.youtube.com/watch?v=PaNUTYBK8EM&index=5&list=PLFIuxLy_v_CVZIDNyLYsO49TGZxcXANil

run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;

SYNTAX FOR DROPPING PLUGGABLE DATABASES
=======================================
drop pluggable database pdb4 (KEEP/INCLUDING) datafiles
drop pluggable database pdb4 INCLUDING DATAFILES;

NOTE YOU CANNOT  DROP READ WRITE DATABASE


PDB MUST BE CLOSED BEFORE DROPPING IT

SQL>alter pluggable database pdb4 close immediate;
SQL>drop pluggable database pdb4 INCLUDING DATAFILES;

run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;