Re: how to drop a databaes manually?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 15 Jul 2001 05:14:00 -0700
Message-ID: <3B518908.D1B1AAF3@exesolutions.com>

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 Received on Sun Jul 15 2001 - 07:14:00 CDT