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.
![]() ![]() |
Allocation
|
There are three possible values:
![]() ![]() ![]()
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.
|