Re: how to drop a database?

From: Kirt Thomas <kremovethisspamthingthomas_at_gfsiinc.com>
Date: Fri, 26 Oct 2001 07:37:31 -0500
Message-ID: <k7mitts22tcg7c144bulopev2f4847u3fn@4ax.com>

I think with 10i you can do an 'alter database drop' - (LOL)

On Thu, 25 Oct 2001 21:21:09 GMT, "Trifon Anguelov" <trifona_at_pacbell.net> wrote:

>
>"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).
>
>
>Hope that helps.
>
>Trifon Anguelov
>Senior Oracle DBA
>
>http://www.dbaclick.com
>
Received on Fri Oct 26 2001 - 07:37:31 CDT