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: Step by Step DBA help required - Uninstalling Oracle Spatial

Re: Step by Step DBA help required - Uninstalling Oracle Spatial

From: bdbafh <bdbafh_at_gmail.com>
Date: Wed, 06 Jun 2007 16:56:00 -0000
Message-ID: <1181148960.208560.287800@h2g2000hsg.googlegroups.com>


On Jun 6, 6:53 am, Number.One.M..._at_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 Received on Wed Jun 06 2007 - 11:56:00 CDT

Original text of this message

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