RE: how to drop a databaes manually?

Hi;

You delete file register ?

Ed Stevens <Ed_Stevens_at_nospam.noway.nohow> escribió en el mensaje de noticias 3b5715e1.990514_at_ausnews.austin.ibm.com...
> 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.)
Received on Thu Jul 19 2001 - 14:24:50 CDT