How to drop a PDB in Oracle Multitenant

Permanently drop a pluggable database. Run from the root.

INCLUDING DATAFILES deletes the PDB datafiles and cannot be undone. The PDB must be closed first. Use KEEP DATAFILES if you only want to remove it from the CDB.

ALTER PLUGGABLE DATABASE &&pdb_name CLOSE IMMEDIATE;

DROP PLUGGABLE DATABASE &pdb_name INCLUDING DATAFILES;

-- Keep the datafiles instead (for example after unplugging):
-- DROP PLUGGABLE DATABASE &pdb_name KEEP DATAFILES;

-- Verify (read-only): should return no rows
SELECT name FROM v$pdbs WHERE name = UPPER('&pdb_name');