Try OpenEdge Now
skip to main content
Managing Table Partitioning in Databases
Managing Table Partitioning in a Database : Creating a table partition : Allocating table partitions

Allocating table partitions

A table partition in an existing database table is used to partition the table based on the values of specified columns. Each partition consists of a set of table rows that match the values specified while defining the partition policy. Based on the policy, all the data present in each field of each table row is placed into the partition. The row data cannot be split across partitions.
As part of creating a partition policy, you also assign a storage area for each table, index, and LOB field, or you can use the default storage areas as defined in the partition policy. You can also specify if or when table partitions must be allocated, as long as the following criteria exist:
*The table exists in the database and has been enabled for table partitioning.
*The table has not been enabled for multi-tenancy.
*Each column that defines the partition policy must be indexable. Partition column names must be indexes; only indexable data can be partitioned. For example, LOBs cannot be indexed so it cannot be part of a partition policy.