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


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.