Re: how to drop a databaes manually?

I don't believe there is any reason to hack the registry just to drop a single database. Using Oradim to delete the service/instance, then deleting all the related files at the OS level should do it.

Now, if you're talking about completely removing Oracle, yes you will need to hack the registry. There are at least two documents on this on MetaLink. I find both documents have more steps than necessary. No need to use the Universal Installer, as it does a very incomplete job anyway. Just stop all the Oracle services, delete a few major keys from the registry, delete the Oracle directories from the file system, and remove any reference to Oracle from the system path.

• Ed Stevens

On Sun, 15 Jul 2001 05:14:00 -0700, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:

>Sybrand Bakker wrote:
>
>> "Victor" <lch_1_at_hotmail.com> wrote in message
>> news:9irjeg$1et1_at_imsp212.netvigator.com...
>> > dear all,
>> >
>> > what is the steps of dropping a database manually?
>> > are there any DROP DATABASE command in oracle?
>> >
>> >
>>
>> 'dropping' a database involves
>> - deleting the instance
>> - deleting the datafiles, controlfiles and online redolog files
>>
>> As you don't specify platform and version I can't provide specific steps.
>> If you would have ever opened an Oracle manual, you would have known there
>> is no drop database command.
>>
>> Regards,
>>
>> Sybrand Bakker, Senior Oracle DBA
>
>In UNIX environments stopping the instance, going to the UNIX prompt and
>deleting the tablespaces, log files, and control files does the trick. In the
>Windows environment one must also use ORADIM to delete Windows services and
>probably manually, dangerous as it gets, clean out the registry. In mainframe
>and other environments differences may exist.
>
>Daniel A. Morgan
>

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)