Skip to Main Content

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!

Validation Problem

154127May 12 2004 — edited May 13 2004
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2004
Added on May 12 2004
2 comments
216 views