Validation Problem
154127May 12 2004 — edited May 13 2004I created this validation:
SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (GEOM, DIMINFO)
FROM streams A, USER_SDO_GEOM_METADATA M
WHERE ROWNUM <= 5000
and M.TABLE_NAME = 'streams' and M.COLUMN_NAME = 'GEOM';
I get a return of > no row selected
I let this go ... and try to index the table
I get this:
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:AAAMOWAAFAAA2wMAAA] 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
ORA-06512: at line 1
This tells me my validation isn't working.
Question is:
What is wrong with my validation statement.
Data was created with the new shp2sdo.