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

egandt_at_gmail.com 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_at_x.washington.edu
(replace x with u to respond)