Re: how to drop a database?

From: Harri Kaukovuo <harri.kaukovuo4_at_nic.fi>
Date: 28 Oct 2001 20:28:05 GMT
Message-ID: <9rhpol$i72$3@news1.song.fi>

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in news:9n%B7.4396$z06.631095459_at_newssvr13.news.prodigy.com:

>
> "Yifat" <zorakani_at_hotmail.com> wrote in message
> news:61f7b40c.0110250922.243681de_at_posting.google.com...

>> How drop I drop a database in NT?
>>
>> I can only mount the database but not open it.
>>
>> Thanks.

>
> Yifat,
>
> 1. Shutdown the database
> 2. Delete all datafiles, control files and redolog files.
> 3. Delete <SID> directory in <ORACLE_HOME>\admin directory.
> 4. Delete any init.ora or PWD<SID>.ora files from
> <ORACLE_HOME>/database. 5. Delete any <SID> entries from
> <ORACLE_HOME>/network/admin/listener.ora and tnsnames.ora files.
> 6. Delete from registry : HKEY_LOCAL_MACHINE -> SYSTEM ->
> CurrentControlSet -> OracleService<SID> and StartService<SID> (only if
> this the only one <SID> on your machine).

For step 6 it might be best to use the oradim -utility.

• Harri

  ---

  Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4

Received on Sun Oct 28 2001 - 14:28:05 CST