COMMIT after INSERT into GEOMETRY fails with ORA-6512 from MDSYS.SDO_IDX
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***
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
This affects customers who upgrade to 10 from 9.2.0.x where x < 6.
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