Oracle Error ORA-54526: multi or composite geometry must be decomposed before extraction

Oracle Error Message

ORA-54526: multi or composite geometry must be decomposed before extraction

Reason for the Error

The extraction could not be performed because the multi or composite geometry must first be decomposed into simple geometries (with or without inner geometries). The multi or composite geometry had a gtype of GTYPE_MULTISOLID, GTYPE_MULTISURFACE, GTYPE_MULTICURVE, GTYPE_MULTIPOINT, or GTYPE_COLLECTION, or the geometry was a line string.

Solution

Use the MULTICOMP_TOSIMPLE parameter to element extractor to decompose the multi or composite geometry to a simple geometry.