Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SDO_RELATE ERROR

503762Apr 3 2006 — edited Apr 4 2006
I 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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 2 2006
Added on Apr 3 2006
6 comments
441 views