OraFAQ Forum: Spatial » Problem with Oracle Spatial query (merged)

Home » Server Options » Spatial » Problem with Oracle Spatial query (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Code: [Select all] [Show/ hide]

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.

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 07:20:15 CDT 2025