Skip to main content
Solved

Hello, I am having difficulty getting the SHAPE field in Oracle to populate correctly. Features are 3D in FME, but the features SHAPE in Oracle are displaying as 2D not 3D after FME translation. How can I resolve this?

  • May 20, 2021
  • 1 reply
  • 22 views

Forum|alt.badge.img
Hello, I am having difficulty getting the SHAPE field in Oracle to populate correctly. Features are 3D in FME, but the features SHAPE in Oracle are displaying as 2D not 3D after FME translation. How can I resolve this?

Best answer by david_prosack88

UPDATE: I was able to resolve the issue. The table in Oracle did not have DIMINFO or spatial index. Once I added DIMINFO into the USER_SDO_GEOM_METADATA table and added a spatial index, it is working.

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.

1 reply

Forum|alt.badge.img
  • Author
  • 64 replies
  • Best Answer
  • May 20, 2021

UPDATE: I was able to resolve the issue. The table in Oracle did not have DIMINFO or spatial index. Once I added DIMINFO into the USER_SDO_GEOM_METADATA table and added a spatial index, it is working.