My Oracle Support Banner

ORA-29902, ORA-13209 and ORA-06512 with Spatial Queries when Spatial Index is Created Using the TTS_TABLE Parameter (Doc ID 1672468.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Getting below error from a simple spatial query on COLA_MARLETS table  -

SQL> desc cola_markets
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 MKT_ID                                    NOT NULL NUMBER
 NAME                                               VARCHAR2(32)
 SHAPE                                              MDSYS.SDO_GEOMETRY

SQL> SELECT c.mkt_id, c.name
FROM cola_markets c
WHERE SDO_RELATE(c.shape,
MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
MDSYS.SDO_ORDINATE_ARRAY(7,7, 8,8)),
'mask=anyinteract querytype=window') = 'TRUE'; 
SELECT c.mkt_id, c.name
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333



Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.