Oracle Error ORA-13372: failure in modifying metadata for a table with spatial index

Oracle Error Message

ORA-13372: failure in modifying metadata for a table with spatial index

Reason for the Error

Modifying the metadata after the index is created will cause an inconsistency between the geometry’s gtype and diminfo.

Solution

Modify (or Prepare) metadata before creating an index on the SDO_GEOMETRY column.