Last updated on AUGUST 04, 2015
Applies to:Oracle Spatial and Graph - Version 10.2.0.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 4-Feb-2013***
Either after upgrading the database from release 10.2.0.3 or lower to 10.2.0.4 and beyond (including 11gR1 and 11gR2) or installing a new 10.2.0.4 database and beyond, cross-schema queries that utilize an Oracle Spatial Index on a Partitioned table fails with:
ERROR at line 2:
ORA-13236: internal error in R-tree processing: [Snapshot too old or Recursive fetch error]
ORA-13234: failed to access R-tree-index table [MDRT Table]
ORA-29400: data cartridge error
ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.SDO_PQRY", line 122
ORA-06512: at line 1
The cross-schema query works just fine if the table is not partitioned.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms