Delete Pluggable Database with Database Configuration Assistant

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

Here we covered Database Configuration Assistant to delete Pluggable database.

In this post, we considered Pluggable database already created, if not then kindly have a look at: Create Pluggable Database using Database Configuration Assistant

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Del_plugdb_1 Del_plugdb_2

 

On “Database Operation” prompt, select the “Manage Pluggable Databases”

In this we can create new pluggable database delete it as well as manage existing pluggable databases.

Click Next to continue.

Del_plugdb_3

 

On “Manage Pluggable Databases” prompt, select the “Delete a Pluggable Database” radio button.

& click Next.

Del_plugdb_4

 

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

In my case, “orcl” is Container Database.

& click Next.

Del_plugdb_5

 

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

& click Next.

Del_plugdb_6

 

Ensure the summary about your provided database, if u wish to continue click Finish button.

Mentioned system01.dbf, sysaux01.dbf & PlugDB_users01.dbf file will be deleted permanently from the container database.

Del_plugdb_7

PlugDB – Pluggable database has been deleted successfully.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Leave a Reply