Re: how to drop a database?

"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 Thu Oct 25 2001 - 16:21:09 CDT