Frequently asked question

How many vertices can be stored in a single SDO_GEOMETRY geometry?

Last Published: April 25, 2020


The limit on vertex count for features stored in SDO_GEOMETRY is 1048576 divided by the number of dimensions in the geometry.

• 2-D: 524288 vertices
• 3-D: 349525 vertices
• 4-D: 262144 vertices

This limit is implicit in the structure of SDO_GEOMETRY. SDO_GEOMETRY.SDO_ORDINATES, the portion that contains the ordinates, is defined as a VARRAY(1048576). The defined size of a VARRAY is its maximum size.

Only applications that deal with very complex geometries are likely to encounter this limitation.

Starting at Oracle 11g R2, it is possible to increase this size limitation to 10M ordinates. See 'Increasing the Size of Ordinate Arrays to Support Very Large Geometries' in the Related Information for more information.

Article ID:000007954

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic