Re: How can I drop a database?

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 28 Oct 2003 23:40:01 +0200
Message-ID: <3f9ee233$1_1@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. Received on Tue Oct 28 2003 - 15:40:01 CST