ORA-13236: internal error in R-tree processing: [Recursive fetch error]
575835May 4 2007 — edited Nov 10 2008Hi All,
The following error was shown whilst running the sql :
CREATE TABLE b2t1h AS
SELECT a.id,b.qid,b.qgeom,b.prec
FROM campparh a, fioh b
WHERE SDO_RELATE (a.geom, b.qgeom,'MASK = ANYINTERACT') = 'TRUE'
Error at Command Line:1 Column:0
Error report:
SQL Error: ORA-29903: error in executing ODCIIndexFetch() routine
ORA-13236: internal error in R-tree processing: []
ORA-13236: internal error in R-tree processing: [Recursive fetch error]
29903. 00000 - "error in executing ODCIIndexFetch() routine"
*Cause: The execution of ODCIIndexFetch routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.
The tables' (campparh and fioh) geomety columns are spatially indexed.
Any help is much appreciated.
Thanks
Zaffar