BUG

Unable to perform spatial queries against a partitioned st_geometry table in Oracle

Last Published: April 25, 2020

Description

Performing a spatial query or using a st_geometry relational operator against a partitioned table with local st_spatial indexes fails with the following Oracle error ORA-29902:

"SQL> SELECT owner, address, parcel_id
2 FROM parcels
3 WHERE st_envintersects(shape,:1,:2,:3:,:4) = 1;

SELECT owner, address, parcel_id
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 906
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "SDE.SPX_UTIL", line 1173
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 137."

Cause

An error is occurring in the sde.spx_util package, when building an internal cursor used for spatial queries or relational operators.

Workaround

Do not use Oracle partitioning with st_geometry attributes when a spatial index is required.

Contact ESRI Support Services if further assistance is required or additional information is needed.

    Article ID:000009716

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options