Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy documentation map : Additional multi-tenant information : Allocation states

Allocation states

The allocation state for an object is either allocated or not allocated. For a table instance either all objects that are part of the table instance are allocated, or none of the objects are allocated.
OpenEdge SQL supports two allocation states:
*Allocated (default) — Allocated implies immediate allocation using the default storage area.
*Not allocated — SQL syntax NO SPACE.
ABL supports three allocation states:
*Immediate allocation — Space is allocated at the time an object is created. This maps to the allocated state.
*Delayed allocation — Space is not allocated. Indicates that customizations to the storage area are required before allocation can occur, and that allocation will happen in a separate step. For example, delayed allocation is required if the tenant will be included in a group.
*Do not allocate — Space is not allocated. Indicates that allocation is not required or not planned for this object.
A database administrator can change the allocation state from not allocated to allocated at a future point, but once space is allocated it is not possible to change the allocation state (without deleting the object and the data for the object).