How to fix the Oracle error ORA-13223: duplicate entry for string in SDO_GEOM_METADATA?

In this post, you’ll learn more about the Oracle ErrorORA-13223: duplicate entry for string in SDO_GEOM_METADATA with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

Reason for the Error ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

There are duplicate entries for the given table and column value pair in the USER_SDO_GEOM_METADATA view.

How to fix the Error ORA-13223: duplicate entry for string in SDO_GEOM_METADATA ?

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

Check that the specified table and geometry column names are correct. There should be only one entry per table, geometry column pair in the USER_SDO_GEOM_METADATA view.