Query using a Spatial Index gives incorrect results after row update if multiple columns have sdo_geometry data

(Doc ID 2327688.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

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.

Cause

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