1 Reply Latest reply: Oct 10, 2007 2:03 PM by 516816 RSS

    ORA-29855

    542856
      Hi,
      I have this problem with spatial index. (table SOUNDING with 82 million records)
      (Oracle 10.2g)

      Here's my command:

      create index SIDX_SOUNDING_SHAPE on SOUNDING(SHAPE)
      indextype is MDSYS.SPATIAL_INDEX;

      Here's the errors:
      create index SIDX_SOUNDING_SHAPE on SOUNDING(SHAPE)
      *
      ERROR at line 1:
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-13249: Error in Rtree: [mdrcrrdmddata, select /*+ PARALLEL(a, 1) */ rid,
      cen  from M6bd_E73E$$ a  where cen >= :1 and cen <= :2], 175245 175246
      ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

      Could someone help fix this problem. What needs to be done?
      Thanks in advance for your help.
      ( I've read a lot of solutions for this type of errors but very confusing.)
      Cuong
        • 1. Re: ORA-29855
          516816
          Cuong,

          There have been a couple of bugs related to the ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I" error. You may want to check Oracle Metalink for an appropriate patch.

          -Justin