Query using a Spatial Index gives incorrect results after row update if multiple columns have sdo_geometry data
Last updated on NOVEMBER 13, 2017
Applies to:Oracle Spatial and Graph - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.2]
Information in this document applies to any platform.
In a table that has at least two columns of spatial data the spatial indexes do not work properly after the data is updated. Incorrect results are returned by queries using a Spatial Index.
Example on a table with two columns of SDO_GEOMETRY datatype and a spatial index created on each.
Following the example, the expected geometries may not be returned when they should which is corrected by either of the following steps:
A. Issue a COMMIT; between steps 3 and 4.
B. ALTER INDEX .... REBUILD on the Spatial Index.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms