I have a problem while executing the below query which involves spatial data.
SELECT A.PBLID, count(*)
FROM TBL1 A, TBL2 B
SDO_RELATE(A.LOC, B.LOC, 'MASK=ANYINTERACT')='TRUE'
AND B.COLUMN like '%A%'
AND SDO_GEOM.RELATE (B.LOC, 'DETERMINE', A.LOC, 0.5) ='OVERLAPBDYINTERSECT'
GAROUP BY A.PBLID
HAVING COUNT(*) > 0
TBL1 has around 14,000+ records and TBL2 has 700000+ records.
When I execute the query the following errors are occuring.
ORA-00604: error occurred at recursive SQL level 1
ORA-13207: incorrect use of the SDO_RELATE operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 401
ORA-06512: at "MDSYS.SDO_CS", line 75
ORA-06512: at "MDSYS.SDO_CS", line 2653
ORA-06512: at "MDSYS.SDO_3GL", line 143
When the same query is executed on lesser records in
TBL1(11412) & TBL2(177354), the query runs fine without any issues.
Can you please suggest me how to resolve this problem or please suggest me any alternate method.
[Duplicates deleted by LF]
[Updated on: Thu, 12 February 2009 15:03] by Moderator
Report message to a moderator