Problems with Multi-Polygon and creating index on it
455028May 15 2006 — edited May 16 2006I have a multipolygon that was created from a SDO_AGGR_UNION and I'm trying to create an index on the geometry. It is failing with...
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAAW8+AAxAAAWdqAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
ORA-06512: at "MDSYS
I'm beginning to think it's an issue with Oracle 9.2.0.1 which is the version of database we are using. Just want to check to see if others have had problems with this.
Here is the geometry of the object.
mdsys.sdo_geometry(2007, 900001, NULL, mdsys.sdo_elem_info_array(1, 1003, 1, 125, 1003, 1, 489, 1003, 1, 739, 1003, 1, 825, 1003, 1, 941, 1003, 1, 1209, 1003, 1, 1237, 1003, 1, 1369, 1003, 1, 1511, 1003, 1, 1551, 1003, 1, 1727, 1003, 1, 2445, 1003, 1, 2547, 1003, 1, 3829, 1003, 1, 3937, 1003, 1, 4085, 1003, 1, 4095, 1003, 1, 4583, 1003, 1, 6149, 1003, 1, 6379, 1003, 1, 6433, 1003, 1, 6465, 1003, 1, 6485, 1003, 1, 6559, 1003, 1, 6577, 1003, 1, 6607, 1003, 1, 6773, 1003, 1, 6793, 1003, 1, 6807, 1003, 1, 6825, 1003, 1, 6833, 1003, 1, 6855, 1003, 1, 6885), mdsys.sdo_ordinate_array(235180.1, 1269688.5, 235179.9, 1269684.4, 235180.6, 1269680.3, 235182.1, 1269676.7, 235184.2, 1269673.3, 235187, 1269670.4, 235190.3, 1269668.1, 235194, 1269666.5, 235197.8, 1269665.6, 235200.8, 1269665.5, 235205.5, 1269666.8, 235230.8, 1269673.6, 235242.3, 1269676.5, 235261.8, 1269681.2, 235270.1, 1269683.2, 235281, 1269685.6, 235296.1, 1269689, 235335.7, 1269696.8, 235368.9, 1269702.5, 235372.8, 1269703.5, 235376.4, 1269705.4, 235379.5, 1269707.8, 235382.2, 1269710.9, 235384.1, 1269714.5, 235385.3, 1269718.3, 235385.7, 1269722.6, 235385.4, 1269726.3, 235384.2, 1269730.2, 235382.3, 1269733.7, 235379.9, 1269736.7, 235370.9, 1269745.9, 235357.1, 1269760.7, 235342.1, 1269778.7, 235332.3, 1269791.1, 235323.8, 1269802.8, 235320.4, 1269807.5, 235313.4, 1269818, 235309.4, 1269824, 235307.2, 1269827.6, 235304.5, 1269830.5, 235301.3, 1269832.8, 235297.7, 1269834.3, 235293.9, 1269835.2, 235289.8, 1269835.2, 235286.1, 1269834.4, 235282.4, 1269832.9, 235279.1, 1269830.6, 235278.1, 1269829.8, 235276.2, 1269825.5, 235274, 1269820.9))