My Oracle Support Banner

RECTIFY_GEOMETRY Fails on 3D Linestrings in 18c with ORA-13199: The Given Geometry Cannot Be Rectified (Doc ID 2563517.1)

Last updated on JULY 19, 2019

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


On Oracle 12c, rectify_geometry worked on 3D linestrings with 2D SRID to removed redundant vertices. 

In 18c, rectify_geometry works if the 2D SRID is set to NULL, but fails otherwise with the following errorstack:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.