AnsweredAssumed Answered

Uninstalling Oracle Spatial

Question asked by geonetadmin on Sep 27, 2012
Latest reply on Oct 4, 2012 by geonetadmin
Original User: nsridb

Over the last few years we have been using ArcSDE on an Oracle RDBMS to hold our spatial data. 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.

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. It is difficult to determine exactly which of our tables/maps are affected or not.

We need to uninstall the Oracle Spatial from our server. 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.

Any help gratefully received.