Re: Delete a databse without using Oracle Console to do so



egandt@xxxxxxxxx wrote:
I need to delete a number of old DBs for which I do not have the
passwords (these are failed restore attempts of a customers DB).  Since
I can not access them I want to remove the from Oracle 10G completely,
however I am finding it very difficult to find information on how to
delete an Oracle database outside of using the Oracle Console, deleting
the physical files associated with a DB is easy, but I still find that
Oracle thinks they exist and thus I can not reuse the SSID, I did at
one point find some information on how to destroy a DB, but I can not
find this anywhere now.  Does anyone know how I can complete this task?


Thanks, ERIC GANDT

Do you know what a database is in Oracle? I don't think so based on what you wrote above. I think you have come to Oracle from SQL Server or another product and have learned nothing about Oracle.

If you truly want to delete a database ... rm -r applied at the
correct location will do quite nicely. Of course at the wrong
location you'll be reinstalling the operating system.

What do you think a database is? Lets clear that up first.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.



Relevant Pages