ORA-13249

From: ennio <ennioj_at_libero.it>
Date: 28 Sep 2006 06:08:38 -0700
Message-ID: <1159448918.716121.143140@i3g2000cwc.googlegroups.com>

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? Received on Thu Sep 28 2006 - 08:08:38 CDT