RE: How to delete database?

If you are in NT, you must delete the Nt service: oradim73 -delete SID In Linux-Unix: you must edit a file in /etc (I don´t remenber the exact name,
may be oratab) and delete the line that start your instance.

Kevin O'Neill <KONEILL_at_WI.RR.COM> escribió en el mensaje de noticias zUwz5.50589$_e4.2331279_at_typhoon.mw.mediaone.net...
> I'm looking to delete a database that was completely trashed. There
 wasn't
> any particular data in it yet, but I'd like to use the same global
 database
> name and SID.
>
> Unfortunately, dbassist has the delete database option greyed out. (What
 that
> means someone can tell me - not a good sign as far as I'm concerned)
>
> The Oracle documentation says, "To drop a database, remove its datafiles,
 redo
> log files, and all other associated files (control files, parameter files,
> archived log files). "
>
> I recorded the filenames from V$LOGFILE and V$DATAFILE and deleted those
> files.
> Data files, redo log files, control files are gone, there didn't appear to
 be
> any archive log files and I'm not sure what parameter files exist(ed).
>
> I can no longer startup the database, but dbassist tells me that my SID is
> already(still) in use.
>
> Thanks for any pointers in the right direction.
>
> Kevin O'Neill
> kto9_at_usa.net
>
>
Received on Mon Sep 25 2000 - 06:13:33 CDT