My Oracle Support Banner

Spatial Query On LOCAL Partitioned Table Does Not Return The Requested Rows (Doc ID 2013063.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


Spatial query on LOCAL partitioned table does not return the requested rows

After inserting rows into a partitioned table, we try to query these rows based on a spatial operator (sdo_filter).
This query does not return any rows.

The execution plan states that the spatial index is used.

When rewriting this query to use the relate function the query returns the expected number of rows.

So far, the issue is resolved by rebuilding the spatial index for the affected partition(s), i.e. the partitions that received new rows when inserting data.

Since our application has not received any signal / exception about the state of the spatial index, it is working with incomplete data.
As a consequence the final result of all spatial processing is wrong, which is a major loss of service.


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.