Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I drop a database?

Re: How can I drop a database?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 27 Oct 2003 19:49:09 +0100
Message-ID: <bnjpb6$hnm$1@news.fujitsu-siemens.com>

"Anna C. Dent" <anacdent_at_hotmail.com> schrieb im Newsbeitrag news:Hpdnb.86441$Ms2.25390_at_fed1read03...
> Volker Hetzer wrote:
>
> > "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
> So?
> It is simple & thorough; while maybe a bit overkill. ;-)
> Redundancy is the best way to teach idiots.
> Redundancy is the best way to teach idiots.
> Redundancy is the best way to teach idiots.
> Redundancy is the best way to teach idiots.
> Sooner or later the lesson gets learned.
So you intentionally gave him advice that would damage his system? Great. Very funny. I can just see this guy laughing.

Volker Received on Mon Oct 27 2003 - 12:49:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US