Thanks
Question
Convert SDO_GEOMETRY to ST_GEOMETRY
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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
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.)