bug number 1099596 or you can add this parameter :_IGNORE_DESC_IN_INDEX = TRUE
thats should do
can someone please help me to tune this query ??? I posted it in here twice, but I guess it was removed for some reason.
here is the query and it Oracle Spatial:
b.grid_lvl1_key, b.grid_lvl1_code, b.grid_lvl1_name,
b.grid_lvl2_key, b.grid_lvl2_code, b.grid_lvl2_name, b.grid_fips_st_code
FROM grid_master a, grid_master b, USER_SDO_GEOM_METADATA M
WHERE m.table_name = 'GRID_MASTER' AND m.column_name = 'SOB_GEOMETRY'
AND SDO_RELATE(A.sob_geometry, B.sob_geometry,'mask=inside querytype=WINDOWDS') = 'TRUE' AND a.grid_key=6909 and b.grid_lvl = a.grid_lvl -1;