ORA-13236 [Snapshot too old or Recursive fetch error] on cross-schema Spatial Query (Doc ID 1303804.1)

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***

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms