How to fix the Oracle error ORA-13364: layer dimensionality does not match geometry dimensions?

In this post, you’ll learn more about the Oracle ErrorORA-13364: layer dimensionality does not match geometry dimensions with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13364: layer dimensionality does not match geometry dimensions

Reason for the Error ORA-13364: layer dimensionality does not match geometry dimensions

The spatial layer has a geometry with a different dimensions than the dimensions specified for the layer.

How to fix the Error ORA-13364: layer dimensionality does not match geometry dimensions ?

You can fix this error in Oracle by following the below steps

Make sure that all geometries in a layer have the same dimensions and that they match the dimensions in the SDO_DIM_ARRAY object for the layer in the USER_SDO_GEOM_METADATA view.