This content has been marked as final. Show 2 replies
While you have Enterprise Edition for the Partioning option I can see why you want to uninstall any of the additional Spatial options to ensure you don't deploy additional cost options to a production environment even though your production code does not use any of these options.
I had a look at the Universal Installer and it is not clear to me either whether ticking the appropriate box will leave you with only Locator or remove Locator+Spatial entirely!
So, I can't help you, other than to experiment with the installer on my database.
1. Logging a call to Oracle support asking for the approved, official method.
2. While waiting for 1, try it on a PC which doesn't have Oracle on it to see what you get. One would think that if one has only Locator then a "Describe mdsys.sdo_geom" should tell you if you have Locator vs Spatial as Locator shouldn't have SDO_UNION and other geoprocessing functions.
Of course, in your $ORACLE_HOME there is the md/admin folder with the installation (and de-installation) scripts. But unless you had clear instructions from Oracle support on which ones to run to achieve your task one would not recommend hacking up a solution using these scripts directly.
Let us know how you go as I am interested in how to do this as well.