Unsupported Oracle Spatial geometries

Last Published: April 25, 2020


All valid Oracle Spatial geometry objects of supported geometry and entity types are supported except for geometries similar to the one described below.


Occasionally, due to a geometry's configuration, an Oracle Spatial geometry object is invalid as an input to ArcSDE.

The following Oracle Spatial geometry is valid using Oracle Spatial validation, but can not be accessed using ArcGIS.

SDO_ELEM_INFO_ARRAY(1, 1003, 1),
21, 80,
21, 79,
20, 79,
20, 80,
21.25, 80,
21, 80))

The last three points form a line that crosses back on itself in a Cartesian coordinate system because they all have the same Y value. The final point is in between the two previous points. This creates a zero area inclusion, which is invalid according to Oracle and ArcSDE.

The geometry's coordinate system is a geographic, or geodetic, coordinate system and the points are longitude and latitude values. However, because Oracle Spatial treats lines in a geographic coordinate system as great circle arcs, it doesn't actually form a zero area inclusion. The two lines are different lengths, so the great circles that they define are slightly different and do not overlay each other.

Solution or Workaround

This is a known limit. Although geographic and geodetic distances can be calculated with ArcGIS, there is no way to store data outside of a Cartesian system.

To rectify this problem, the geometry must be changed to remove the included area.

    Article ID:000011629

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic