COMMIT after INSERT into GEOMETRY fails with ORA-6512 from MDSYS.SDO_IDX (Doc ID 342280.1)

Last updated on OCTOBER 31, 2013

Applies to:

Oracle Spatial and Graph - Version 10.1.0.2 to 10.1.0.4 [Release 10.1]
Oracle Spatial and Graph - Version 10.2.0.1 to 10.2.0.1 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Nov-2013***


Symptoms

An insert or update on a Spatial table (contains SDO_GEOMETRY column) having a Spatial index succeeds, but when performing a commit the following error shows up:

ORA-00604: error occurred at recursive SQL level 1
ORA-06512: at "MDSYS.SDO_IDX", line 184
ORA-06512: at line 1

This happens for ALL Spatial tables/indexes and is seen after having upgraded from a 9.2.0.x version where x < 6.

A tracefile with event 10046 will show something like:

PARSING IN CURSOR #1 len=79 dep=1 uid=54 oct=47 lid=54 .....
begin mdsys.sdo_idx.cmt_idx_chngs('LOCALDATA', 'MATTEST1_SX', null, 0);end;
...
ERROR #1:err=6512 tim=453826390

Changes

This affects customers who upgrade to 10 from 9.2.0.x where x < 6.

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