Create a new partition or change an existing partition according to whether one or more values in a row fall within a range of
predefined values for the partition.
Note: Semantic partitioning must be enabled in order to create hash, list, or range partitions.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select the table for the partition.
- Select Properties.
- Select Partitions.
- Choose to create a new partition or change an existing partition.
- In the Select Partition Strategy window, choose Range.
- In the Select Partition Key Columns window, use the arrow buttons to select partition key columns.
Partition key columns are table columns that determine how the
table is to be partitioned.
- In the Partition Specification window, specify the name of the partition, the range of values, and where the partition will reside.
- (Optional) Click Summary to verify your selected options.