SDO_RELATE ERROR
503762Apr 3 2006 — edited Apr 4 2006I am having difficultly performing what seems to be a simple task using the SDO_RELATE function.
I have two tables: TOLER_PT A and TOLER_POLY B
A has 40,000 records that contain points SRID = 41079. This is the location of accidents within Montana
B has 56 records that contain polygons SRID = 41079. This is the counties for Montana.
I am using SDO_RELATE to show me what county the accident took place in.
When perform the query and limit the accidents to 1000 records, this select
statement works fine. However if I try to do more than 2000, I get the following error.:
ERROR:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [SDO_RTREE_RELATE] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 257
ORA-06512: at line 1
Here is the query I am running from sqlplus
select A.tc_x_coord X,A.tc_y_coord Y,B.NAME
from GEOSPATIAL.TOLER_PT A, GEOSPATIAL.TOLER_POLY B
where A.TC_SEQUENC < 5000 AND SDO_RELATE(A.GEOMETRY,B.GEOMETRY,
'mask=anyinteract querytype=WINDOW') = 'TRUE'
/
We are running O SPATIAL 9.2.0.5.0
Here is the data from user_sdo_geom_metadata for TOLER_PT
TABLE_NAME
--------------------------------
COLUMN_NAME
-----------------------------------------------------------------------------------------------
DIMINFO(SDO_DIMNAME, SDO_LB, SDO_UB, SDO_TOLERANCE)
-----------------------------------------------------------------------------------------------
SRID
---------
TOLER_PT
GEOMETRY
SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 444428, 816221, 0), SDO_DIM_ELEMENT('Y', 226891, 267080, 0))
41079
Here is the data from user_sdo_geom_metadata for TOLER_POLY
TABLE_NAME
--------------------------------
COLUMN_NAME
----------------------------------------------------------------------------------------------------
DIMINFO(SDO_DIMNAME, SDO_LB, SDO_UB, SDO_TOLERANCE)
----------------------------------------------------------------------------------------------------
SRID
---------
TOLER_POLY
GEOMETRY
SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 111862, 1030194, 0), SDO_DIM_ELEMENT('Y', 17695, 547987, 0))
41079
Any help would be appreciated.