One sure fire method for deletion would be:
rm -R *
this works best if you can do an su first.
But if you want to keep you job you can log in as sys and do an alter database backup controlfile to trace, shut down the database and look for the file in the trace directory and it will tell you where all of the files are located. If this was NT/2000/XP then you could use the ORADIM command to remove the database. If it is Unix and you don't want to try the previous method then you need to delete the database files and edit the following files: oratab, tnsnames.ora and listener.ora, removing any references to the database you are deleting. You could also just shut down the database and set the :Y to :N for that database in the oratab to keep it from restarting on reboot. Becuase as soon as you delete the database someone will want it. I deleted an Oracle 8.0.6 database recently and the next day someone wanted it to compile some old code. Just my thoughts.
If u delete the way suggested by all these guys will ofcourse do, but if u have WIN as OS then the registry contents will be left with & u cant do anything but to delete manually if u know have knowledge of contests in registry .
If u delete manully all the said files and say u want to create a new DB with that DB name u were using, OS will not allow u to do so as u r left with registry contents.....
S if u use ORDIM then it will delete service & contents in registry as well.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
I hope someone from Oracle is reading this!? Goes in the same category as uninstalling version 7 in NT. Rumours have it that version 12i will come bundled with crow-bar, flame-thrower and machette (part of DBA Studio).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman