English

FAQ: How does ArcSDE handle Oracle Spatial application-specific geometry elements?

Question

How does ArcSDE handle Oracle Spatial application-specific geometry elements?

Answer

When reading SDO_GEOMETRY objects containing SDO_ETYPE 0 elements, ArcSDE will ignore the SDO_ETYPE 0 data and pass only the well-defined geometry elements to the application; therefore, ArcGIS will not receive the SDO_ETYPE 0 geometry elements.

When ArcSDE is used to update SDO_GEOMETRY objects containing SDO_ETYPE 0 elements, these elements will not be preserved; only the well-defined geometry elements will be preserved. In situations where SDO_ETYPE 0 data must be preserved, you should make sure users don't have UPDATE access to any tables that contain SDO_ETYPE 0 elements.