| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: How to DROP an Oracle Database?
Answer: 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. |
| March 03, 2009 06:51:10 |
#3 |
| rajat_dua |
Member Since: March 2009 Total Comments: 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 |
| |
Back To Question | |
