Re: How can I drop a database?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 27 Oct 2003 19:07:47 +0100
Message-ID: <bnjmtm$crt$1@news.fujitsu-siemens.com>

"Anna C. Dent" <anacdent_at_hotmail.com> schrieb im Newsbeitrag news:a8dnb.86439$Ms2.25245_at_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.
Which will also delete the oracle software.

Lots of Greetings!
Volker Received on Mon Oct 27 2003 - 12:07:47 CST