|
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.
|