Home » Server Options » Spatial » Problem with Oracle Spatial query (merged)
Problem with Oracle Spatial query (merged) [message #386025] Thu, 12 February 2009 04:44
MSAM123
Messages: 29
Registered: June 2007
Junior Member
Hi All,

I have a problem while executing the below query which involves spatial data.

SELECT A.PBLID, count(*) 
FROM TBL1 A, TBL2 B
WHERE 
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.


Thanks,
MSAM

[Duplicates deleted by LF]

[Updated on: Thu, 12 February 2009 15:03] by Moderator

Report message to a moderator

Previous Topic: How to convert (x,y) cordinate to longitude and latitude
Next Topic: ORA-29902,ORA-13209 and ORA-06512
Goto Forum:
  


Current Time: Thu Mar 28 04:21:14 CDT 2024