GeekInterview.com
  I am new, Sign me up!
 
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: 4 Last Update: August 06, 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
August 05, 2009 01:00:44   #4  
mahender.komat Member Since: August 2009   Contribution: 1    

RE: How to DROP an Oracle Database?
SHUTDOWN IMMEDIATE;

STARTUP RESTRICT MOUNT;
DROP DATABASE;

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape