Re: SPATIAL INDEX

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 23 Sep 2006 03:07:28 GMT
Message-Id: <pan.2006.09.23.03.07.27.773744@gmail.com>

On Thu, 21 Sep 2006 07:12:37 -0700, ennio wrote:

> When I try to use SDO_WITHIN_DISTANCE function on two tables,it gives
> error :
> ORA-13226
> Saying that the interface is not supported with no spatial indexes
> Even if the tables contains spatial indexes

SDO_WITHIN_DISTANCE is an operator. It requires properly built Spatial indexes. If you are using multiple geom definitions, you need to add the geom restriction as well (never a bad idea to do so anyway).

Database version, table def's for both tables, sdo_metadata for both tables, and spatial index definitions would be needed to proceed on the analysis.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Sep 22 2006 - 22:07:28 CDT