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: Anna C. Dent <anacdent_at_hotmail.com>
Date: Mon, 27 Oct 2003 10:24:39 -0800
Message-ID: <Hpdnb.86441$Ms2.25390@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. Received on Mon Oct 27 2003 - 12:24:39 CST

Original text of this message

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