My Oracle Support Banner

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 MARCH 09, 2019

Applies to:

Oracle Spatial and Graph - Version to [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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.