Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.ision.net!newsfeed2.easynews.net!ision!newsfeed.freenet.de!border2.nntp.ams.giganews.com!nntp.giganews.com!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!h2g2000hsg.googlegroups.com!not-for-mail
From:  bdbafh <bdbafh@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Step by Step DBA help required - Uninstalling Oracle Spatial
Date: Wed, 06 Jun 2007 16:56:00 -0000
Organization: http://groups.google.com
Lines: 30
Message-ID: <1181148960.208560.287800@h2g2000hsg.googlegroups.com>
References: <1181127203.793652.27300@o5g2000hsb.googlegroups.com>
NNTP-Posting-Host: 69.142.196.48
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1181148960 16436 127.0.0.1 (6 Jun 2007 16:56:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 Jun 2007 16:56:00 +0000 (UTC)
In-Reply-To: <1181127203.793652.27300@o5g2000hsb.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: h2g2000hsg.googlegroups.com; posting-host=69.142.196.48;
   posting-account=rcQZawwAAAALUCo-zZUVUQgj4l_8W6zb
Xref: news.f.de.plusline.net comp.databases.oracle.server:199032

On Jun 6, 6:53 am, Number.One.M...@gmail.com wrote:
> Hi,
>
> I'm standing in for our DBA while he has some much needed annual
> leave.  I'm not a DBA but know my way around the database.  I've had a
> request come in that one of our DB's has had Oracle Locator and Oracle
> Spatial installed on it.  In fact they only want Oracle Locator
> installed on it and so have requested for the Spatial aspect to be
> uninstalled.
>
> Would anyone be able to provide me with reliable step by step
> instructions on how to do this, or point me at a Metalink note on the
> subject?  The DB holds lots of highly used accounts, the one thing I
> can't do is trash it while I try.  If uninstalling spatial is high
> risk (for me) I would much rather leave it until the DBA returns.
>
> The DB is 10.2.0.3 on GNU Linux.
>
> Thanks in advance,
>
> Mike.

There is no try in production.
This can get messy - best leave it for the DBA.
If you want to run through a test of it in testing, first test the
backup/restore/recovery procedures as you may need to rollback the
entire routine.

-bdbafh