Convert from SDE.ST_GEOMETRY to SDO_GEOMETRY easily?

Question

We have a clients data pump export installed in an Oracle 11g database with ARCSDE 10 to fix some bugs with our application. We would like to do some testing with this same data set but as SDO_GEOMETRY instead of the SDE.ST_GEOMETRY. Is there any way to easily convert?

Thanks,

Milton S.

VinceAngelo · Answer

This isn't a "conversion" exercise as much as a "recreation" one.  As such, I doubt there's much to be found (I would never use a script found on the web for my data population needs, so I've never looked).  The core of data transfer could be very simple (an INSERT INTO with a SELECT), but creation of the target tables shouldn't be left to chance.

- V

Tharuunyad · Answer

are there any sample  sql programs which enable the conversion from SDE.ST_Geometry to SDO_GEometry ?

MarcoBoeringa · Answer

In addition, if you have older datasets (originally created prior to ArcGIS 9.2) in "basic precision", take notice of the following warning ESRI makes in the Help link Vince posted, it is probably also wise to take this into account when doing a simple "manual" transition as I suggested by creating a new Feature Class with different storage type:

"If you are converting the spatial column type, the data must be stored in high precision. If your data is currently stored with basic precision, you must first migrate it to high precision before you migrate the storage type. This can be done with either the Upgrade Spatial Reference geoprocessing tool or the sdelayer command with the alter operation. See Migrating to high precision for information on migrating the precision of a dataset."