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: Joel Garry <joel-garry_at_home.com>
Date: 29 Oct 2003 17:17:21 -0800
Message-ID: <91884734.0310291717.6363526c@posting.google.com>


"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<bnjpb6$hnm$1_at_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

Not only that:

$ ll -R $ORACLE_HOME|grep root            
drwxr-xr-x   2 root       sys             96 Aug 15 11:24 oracle
-rwxr-xr-x   1 oracle     dba             10 Aug 15 20:03 root.sh
-rwxr-xr-x   1 oracle     dba             10 Aug 15 20:03 root.sh.old
-rwsr-s---   1 root       dba        9580544 Aug 15 19:52 dbsnmp
lrwxrwxr-x   1 root       sys             37 Aug 15 12:02 runInstaller
-> /orclinst/oui/install/runInstaller.sh

Darwinism is far too slow.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/business/20031029-9999_1b29prgn.html
Received on Wed Oct 29 2003 - 19:17:21 CST

Original text of this message

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