Bug: Unable to perform spatial queries against a partitioned st_geometry table in Oracle
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."
An error is occurring in the sde.spx_util package, when building an internal cursor used for spatial queries or relational operators.
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.