Re: ORA-13249

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 1 Oct 2006 23:19:08 -0700
Message-ID: <1159769948.535945.67090@b28g2000cwb.googlegroups.com>

ennio wrote:
> hi I have occured in this error ;
>
>
> SQL> SELECT/*+ INDEX (montane, mont_idx)*/ A.id id,B.id id FROM montane
> A,montan
> e B where SDO_NN (a.geom,b.geom,'sdo_num_res=1',1)='TRUE';
> SELECT/*+ INDEX (montane, mont_idx)*/ A.id id,B.id id FROM montane
> A,montane B w
> here SDO_NN (a.geom,b.geom,'sdo_num_res=1',1)='TRUE'
> *
> ERRORE alla riga 1:
> ORA-13249: SDO_NN cannot be evaluated without using index
> ORA-06512: a "MDSYS.MD", line 1723
> ORA-06512: a "MDSYS.MDERR", line 17
> ORA-06512: a "MDSYS.PRVT_IDX", line 9
>
>
> but montane table has a spatial index .....
> also similar function like SDO_WITHIN regulary works
> ......
> I can do?

No Oracle version/patchset level, no platform information, no DDL for the table nor index... It's hard to tell what might be causing this error without additional detail.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Oct 02 2006 - 01:19:08 CDT