How to fix the Oracle error ORA-13265: geometry identifier column string in table string is not of type NUMBER?

In this post, you’ll learn more about the Oracle ErrorORA-13265: geometry identifier column string in table string is not of type NUMBER with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13265: geometry identifier column string in table string is not of type NUMBER

Reason for the Error ORA-13265: geometry identifier column string in table string is not of type NUMBER

GID column is not of type NUMBER.

How to fix the Error ORA-13265: geometry identifier column string in table string is not of type NUMBER ?

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

Alter the table definition such that the column containing the geometry identifier (GID) is of type NUMBER.