Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I drop a database?
Thank you all for your advices.
Loc Tran
"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message news:
3f9d6944$0$21649$afc38c87_at_news.optusnet.com.au...
>
> "Loc Tran" <phuoc-loc.tran_at_umontreal.ca> wrote in message
> news:44dnb.13153$P42.11578_at_charlie.risq.qc.ca...
> > Hi,
> >
> > 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?
>
> An old paper of mine at www.geocities.com/lydian_third tells you the two
> ways of doing this.
>
> Regards
> HJR
>
>
Received on Mon Oct 27 2003 - 14:06:19 CST