Try OpenEdge Now
skip to main content
Table Partitioning
Introducing Table Partitioning : Defining partitions : Defining a partition policy detail
 

Defining a partition policy detail

Defining a partition policy detail record requires you to define the attributes of one specific partition. The properties of the partition policy detail are listed in the following table:
Table 2. Partition policy record
Property
Description
Name/Description
A unique name of the partition policy detail; it corresponds to the partition name. Do not use spaces or special characters such as the asterisk (*), the ampersand (&), and the period ( . ).You can use the underscore (_) character in addition to alphanumeric.
Values
Specifies a column value.
*If the partition column is based on list, the comparison operator is EQ (equal to). Provide a value that matches exactly a column value.
*If the partition column is based on range, the comparison operator is LE (less than or equal to). Provide a valid upper bound.
Allocation
There are three possible values:
*Allocated
*Composite
*Split-target.
Composite and Split-target are used in migrating existing table data. For new partitioned tables, specify Allocated to indicate that space is to be allocated to the partition, if you are ready to allocate space.
Default data area
The default value is inherited from the parent partition policy definition. Use this property to assign another area for the partition’s data.
Default index area
The default value is inherited from the parent partition policy definition. Use this property to assign another area for the partition’s indexes.
Default LOB area
The default value is inherited from the parent partition policy definition. Use this property to assign another area for the partition’s LOBs.