We can delete Pluggable database using Database Configuration Assistant (DBCA) OR manually from SQL prompt as sysdba privilege.

Here I have covered DBCA to delete Pluggable database in silent and GUI mode.

GUI:

Start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

On “Database Operation” prompt, select the “Manage Pluggable Databases”.Click Next to continue.

dbca1

Select the “Delete a Pluggable Database” radio button & click Next.

dbca2

On “Database List” prompt, select the Container Database.

dbca3

On “Delete Pluggable Database” prompt, select pluggable database to be deleted from drop down list & click Next.

dbca4

Review summary about your provided database and click Finish button.

dbca5

PDB2 – Pluggable database has been deleted successfully.

Thanks

Mandy

Leave a Reply