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. 
  • Interview Candidate
  • 13
  • 33692

Showing Answers 1 - 13 of 13 Answers

V.A.SURESH

  • Nov 14th, 2005
 

go to dbca and click on delete database

  Was this answer useful?  Yes

charles_ch27

  • 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