Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

DBA - Pluggable Database: Drop Pluggable Database

Back

• DBA - Pluggable Database: Drop Pluggable Database
  • Drop Pluggable Database
    • Lab: Drop a pluggable database using SQL
    • Lab: Drop a pluggable database using DBCA

---

Drop Pluggable Database

• prerequisite:

  • current session in the root
  • the target pdb is close

• Statement:

DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;

• When sucessfully dropping a PDB, its service will be autimatically removed from the listener.

---

Lab: Drop a pluggable database using SQL

-- confirm current in root
show con_name;

-- error if pdb is not closed
DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;
#ERROR at line 1:
#ORA-65025: Pluggable database PDB2 is not closed on all instances.

-- close target pdb
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
-- drop pdb
DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;

-- confirm
SELECT name, open_mode FROM v$pdbs;

• The dir of the pdb is empty, and can be removed.

---

Lab: Drop a pluggable database using DBCA

---

TOP