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!

Geometry cannot be rectified

626119Feb 12 2009 — edited Feb 17 2009

I am trying to execute the following SQL sentence to correct my polygon geometry inside a SDO layer )not just returning the error list with a select sentence)

update rlv.dkn a set a.GEOM=sdo_util.RECTIFY_GEOMETRY(a.GEOM,0.0005) where substr(sdo_geom.validate_geometry_with_context(a.GEOM,0.0005),1,5) in ('13349');

I am getting an error

Error at line 1
ORA-13199: the given geometry cannot be rectified
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_UTIL", line 636

I would just like to correct the geometry to be able to recreate spatial indexes correctly.

Any suggestions how to correct my geometry?

Dejan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2009

Added on Feb 12 2009

#database-key-features, #spatial

12 comments

3,577 views