FAQ: How many vertices can be stored in a single SDO_GEOMETRY geometry?
How many vertices can be stored in a single SDO_GEOMETRY geometry?
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.
- Oracle 11g Rel 2 Documentation: Increasing the Size of Ordinate Arrays to Support Very Large Geometries
- Oracle 11g Rel 2 Documentation: Spatial Data Types and Metadata