Re: How can I drop a database?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 28 Oct 2003 05:51:43 +1100
Message-ID: <3f9d6944$0$21649$afc38c87@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 - 12:51:43 CST