When using the Data Interoperability tool with Oracle Spatial, compound polygons in SDO_GEOMETRY are converted to simple polygons

Last Published: April 25, 2020


When copying a compound polygon or line feature (SDO_GEOMETRY) with the Data Interoperability extension from one table to another, arcs in compound lines and polygons are converted into line segments.


The conversion of compound polygons or lines to simple polygons or line segments is the default behavior of the Data Interoperability product.

The addition of enhanced geometry model support allows lines and polygons containing arcs to be maintained, rather than stroked or the geometry being split up into multiple segments. It also provides the ability to truly hold measures.

For more information, see the 'Geometry Handling' topic under the 'Workbench Advanced Settings' section of the Data Interoperability Help.

Solution or Workaround

To retain compound polygons and lines during a translation from source to destination, the Geometry Handling parameter in the Spatial ETL tool must be changed from Basic to Enhanced.
  1. In the Navigator pane, go to Tool Settings > Advanced > Geometry Handling.

    Valid values are 'Enhanced' and 'Classic', with the default value being 'Classic'.
  2. Select 'Enhanced'.

    Compound polygons and lines will now be retained, and not converted to simple line segments when copying.

Article ID:000010693

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options