How to DROP an Oracle Database?

You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using:

1) select * from dba_data_files;
2) select * from v$logfile;
3) select * from v$controlfile;
4) archive log list
5) initSID.ora
6) In addition you can clean the UDUMP, BDUMP, scripts etc

Clean up the listener.ora and the tnsnames.ora. make sure that the oratab entry is also removed. 

Showing Answers 1 - 5 of 5 Answers


  • Nov 14th, 2005

go to dbca and click on delete database

  Was this answer useful?  Yes


  • Apr 4th, 2007

In Oracle 10g, there is a new command to drop an entire database.

Startup restrict mount;
drop database <instance_name>;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions