Oracle 10g uninstallation
![oracle 10g uninstallation oracle 10g uninstallation](https://www.xtivia.com/media/Using-the-SC-cmd-to-Remove-Orphaned-Hosed-up-Oracle-Services-from-Window-OS.jpg)
I'm not sure we have Intermedia installed, if we install it will it replace the MDSYS.SDO_GEOMETRY type definition? and if we uninstall Oracle Spatial after that will it leave the sdo_geometry type in there as it was installed with Intermedia as well? Unfortunately there are a lot of maps and these are live systems. I'm getting a bad feeling about this and beginning to think we are going to end up haveing to export all our maps and reimport them using the ST_GEOMETRY. The ArcSDE layers which had spatial columns defined as SDO_GEOMETRY were using the mdsys.sdo_geometry type and therefore have stopped working. Unfortunately now we have uninstalled Oracle Spatial it has removed the SDO_GEOMETRY type definition which was in the MDSYS schema. I therefore thought we would be safe uninstalling Oracle spatial. OK we created a duplicate server and checked out the mdsys.all_geometry_columns table and it was empty, so I figured this was evidence that we had never actually used Oracle spatial and created any table using it. You can even use the duplication process to verify your backup procedures,īecause you'll want to be sure they're up to snuff before making changes like type migration Run through the Spatial uninstall procedure, to see if it damages your ArcGIS/ArcSDE install Loaded, install a representitive sample (or the whole database, if you have the space) and What you should probably do is create a new instance, with Spatial and whatever you have Them, and I'm not much of a "migrate" fan, preferring to reload (and optimize while I'm at it).
![oracle 10g uninstallation oracle 10g uninstallation](https://docs.oracle.com/cd/B25329_01/doc/admin.102/b25610/img/gs_home_page.gif)
There are migration tools to convert SDO_GEOMETRY into ST_GEOMETRY, but I haven't used Of an ArcGIS Server competitor) and can still use SDO_GEOMETRY when needed. I never install Oracle Spatial (which is more Intermedia, which is part of the base 11g install. SDO_GEOMETRY, but SDO_GEOMETRY is not part of Spatial. There's a big difference between Oracle Spatial and SDO_GEOMETRY. Can anyone advice me what would be the implications of this? Is there any easy way of converting all the SDO_CEOMETRYS to ST_GEOMETRY? or will I have to export all the maps, change the dbtune geometry storage instructions and reload all the maps and then uninstall Oracle Spatial once we are sure none of the maps are using the SDO_GEOMETRY structure. We need to uninstall the Oracle Spatial from our server. It is difficult to determine exactly which of our tables/maps are affected or not. It now transpires that at some point in the past someone installed Oracle Spatial on the server and it appears that the default dbtune keyword uses the SDO_GEOMETRY storage type. I am the DBA for this system and it was my understanding that we weren't using Oracle Spatial as we don't have a licence for it and thus we have always done all our Spatial work using ArcSDE clients. Over the last few years we have been using ArcSDE on an Oracle RDBMS to hold our spatial data.