Locations Spatial Index Rebuild Failed Read User_sdo_geom_metadata
(Doc ID 736113.1)
Last updated on OCTOBER 04, 2022
Oracle Trading Community - Version 11.5.10 to 22.214.171.124 [Release 11.5] Information in this document applies to any platform.
The concurrent program "Locations Spatial Index Rebuild" creates the index HZ_LOCATIONS_N15 which is failing with the error message:
The following SQL error occurred: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13203: failed to read USER_SDO_GEOM_METADATA table ORA-13203: failed to read USER_SDO_GEOM_METADATA table.
The problem is: SQL> select SDO_OWNER,SDO_COLUMN_NAME from mdsys.sdo_geom_metadata_table where sdo_table_name='HZ_LOCATIONS';