GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration
Go To First  |  Previous Question  |  Next Question 
 Database Administration  |  Question 79 of 231    Print  
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. 



  
Total Answers and Comments: 3 Last Update: March 03, 2009   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 14, 2005 04:40:17   #1  
V.A.SURESH        

RE: How to DROP an Oracle Database?
go to dbca and click on delete database
 
Is this answer useful? Yes | No
April 04, 2007 00:25:55   #2  
charles_ch27        

RE: How to DROP an Oracle Database?
In Oracle 10g there is a new command to drop an entire database.

Startup restrict mount;
drop database <instance_name>;

 
Is this answer useful? Yes | No
March 03, 2009 06:51:10   #3  
rajat_dua Member Since: March 2009   Contribution: 5    

RE: How to DROP an Oracle Database?
DBA should never drop a database via OS level commands
rather use GUI utility DBCA to drop the database

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape