Hello,

I am suddenly obtaining an ORA-13249 error for a query which worked fine until today.


QUERY:
--------------------------------------------------------------------
SELECT /*+ index(cnngeo_spatial_idx) */ /*+ index(geo_spatial_idx) */
nb.vehicle_tag, nb.train_assignment, nb.heading,
cnngeo.CNAME AS Intersection, nb.report_time, nb.latitude,
nb.longitude,nb.speed, nb.train_assignment, nb.last_timepoint

FROM bus_master.positions@avl_187 nb, sf_addresses geo, cnngeo

WHERE sdo_nn(geo.geom,mdsys.sdo_geometry(2001,8307,mdsys .sdo_point_type(nb.longitude,nb.latitude,null),nul l,null), 'sdo_num_res=1') = 'TRUE'

AND sdo_nn(cnngeo.geom,mdsys.sdo_geometry(2001,8307,md sys.sdo_point_type(nb.longitude,nb.latitude,null), null,null), 'sdo_num_res=1') = 'TRUE'

AND nb.report_time between to_date('21-Jul-04 01:00:00 AM','DD-MON-YY HH:MI:SS AM')

AND to_date('22-Jul-04 01:00:00 AM','DD-MON-YY HH:MI:SS AM');
---------------------------------------------------------------------

I recreated indices on both tables just as a check.

I double checked the coordinate values being returned via nb.latitude and nb.longitude using QUERY:


SELECT nb.latitude, nb.longitude
FROM bus_master.positions@avl_187 nb
WHERE nb.report_time between to_date('21-Jul-04 01:00:00 AM','DD-MON-YY HH:MI:SS AM')
AND to_date('22-Jul-04 01:00:00 AM','DD-MON-YY HH:MI:SS AM');

They were in the correct range.

Any suggestions would be greatly appreciated