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