Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-13033 Error

619640Mar 16 2009 — edited Mar 17 2009

Recently transitioned our GIS data from Sun Solaris (64-bit) running Oracle 10.2.0.3. to Microsoft Windows (64-bit) running Oracle 10.2.0.4. All seems to work well, except for a number of linear geometries that report ORA-13033 error upon validation. The problem does not appear on 10.2.0.3 environment. Has anything changed in 10.2.0.4 that may be casuing this. The data was brought over using traditional Oracle imp/exp syntax. The error is being reported on a 50% of the elements, hence the concern.

CREATE INDEX DPW.WTR_PRESSURE_CONTOUR_SIDX ON DPW.WTR_PRESSURE_CONTOUR(GDO_GEOMETRY)INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('WORK_TABLESPACE = SDO_WORK TABLESPACE=SPATIAL_INDEX LAYER_GTYPE=LINE' )
Error at line 1
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:AAANGVAAJAAAOgeAAE] 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.SDO_INDEX_METHOD_10I", line 10

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 16 2009

#database-key-features, #spatial

1 comment

1,273 views