Re: How can I drop a database?

From: Anna C. Dent <anacdent_at_hotmail.com>
Date: Mon, 27 Oct 2003 10:05:58 -0800
Message-ID: <a8dnb.86439$Ms2.25245@fed1read03>

Loc Tran wrote:

> 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.

One straightforward way is to use "find /" to identify every file owned by "oracle" & remove it from the filesystem. Received on Mon Oct 27 2003 - 12:05:58 CST