Re: Delete a databse without using Oracle Console to do so
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Thu, 28 Jul 2005 13:10:45 -0700
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) .
- References:
- Prev by Date: Re: Sybrand Bakker: Gets humiliated in public?
- Next by Date: Re: Sybrand Bakker: Gets humiliated in public?
- Previous by thread: Delete a databse without using Oracle Console to do so
- Next by thread: Re: Delete a databse without using Oracle Console to do so
- Index(es):
Relevant Pages
|