Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I drop a database?
"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message
news:3f9ee233$1_1_at_news.estpak.ee...
> > > I just install for the first time an Oracle rdbms on a HP-UX server.
> > > Unfortunately, when asking to give the database file location, i write
> out
> > > /u02/oradata/UVISTEST instead of /u02. So now the files like
> control?.ctl,
> > > redo0?.log and *.dbf are under the repertory
> > > /u02/oradata/UVISTEST/oradata/UVISTEST. It's why I would like to drop
> the
> > > database UVISTEST and recreate it in the proper repertory.
> > > The question is: how to do to drop a database and recreate it under
> > Oracle.
> > >
> > > Loc Tran
> >
> >
> > Instead of simply blowing the dtaabase away and creating afresh, why
don't
> > you take this opportunity to learn a much subtler and more useful skill:
> how
> > to move controlfiles and datafiles and redo logs?
>
> Or just upgrade to 10g and use drop database;)
>
> Tanel.
>
>
Ha, talking about overkill. Received on Tue Oct 28 2003 - 19:28:09 CST