This discussion is archived
1 Reply Latest reply: Oct 10, 2007 12:03 PM by 516816 RSS

ORA-29855

542856 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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