Thanks
I have an ESRI file geodatabase and would like to insert it into an Oracle table in ST_GEOMETRY format. The Oracle Spatial writer, however, seems to write only SDO_GEOMETRY. Is there a way to get it to write ST_GEOMETRY?
Page 1 / 1
afiak, you cannot store SDE.ST_GEOMETRY in Oralce SDO.
You need to convert it.
Theoreticcaly something like this should work in oracle, so maybe if u use a SQLExecutor or a SQLCreator with a selection like this might work:
SELECT MDSYS.SDO_GEOMETRY(SDE.ST_AsText(a.shape),SDO_SRID) FROM my_ESRI_ST_GEOMETRY_table a;
(have not tried this myself btw. The example is quoted from the Oracle community.)