Is there any command to delete the existing database.
I know that it can be done using dbassist; but want to know how to do it manually
There is no command as such to delete the Database.
Just delete all the files.
Hope it helps.
How to delete existing oracle manually?
1. Shutdown the instance and Stop all oracle services that r runnig presently.
from control panel utility.
2. Delete all those services through regedit.
3. Delete the Oracle installed directory .
1. Shutdown the database.
2. Delete Oracle servoce files ( or file that will created while runing rninstaller from /etc )
3. Remove oracle directory.
Let me know ur views.
If you want to delete the database then delete the following files
shutdown the database
entry from the /var/opt/oratab file or equiv registy entries from NT...
If you want to delete the oracle software .Then follow the steps mentioned by kutty.
After stopping Oracle services. You should use ORACLE installer to uninstall it. Then you should delete the files and the entries in the Registry.
remove all files from
select name from v$datafile
select name from v$controlfile
select member from v$logfile
Oracle provides a tool called database configuration assistant (DBCA), this gives you option to delete a database. It will also delete services and all files assocaited with database in Windows environment. In Unix environment the executable is called dbca and you can delete the database.
Click Here to Expand Forum to Full Width