Frequently asked question

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

Last Published: December 7, 2023


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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options