Splitting a Partition for a List Partitioned Table

For example, assume that the range defined for the partition channel2 of the list partitioned table list_sales is ('6', '7', '8', '9'). You can specify the split point ('6', '7') to split the channel2 partition into two partitions and update the global index.

ALTER TABLE list_sales SPLIT PARTITION channel2 VALUES ('6', '7') INTO
(
    PARTITION channel2_1, -- The first partition range is ('6', '7').
    PARTITION channel2_2  -- The second partition range is ('8', '9').
) UPDATE GLOBAL INDEX;

Alternatively, split the partition channel2 into multiple partitions without specifying a split point, and update the global index.

ALTER TABLE list_sales SPLIT PARTITION channel2 INTO
(
    PARTITION channel2_1 VALUES ('6'),
    PARTITION channel2_2 VALUES ('8'),
    PARTITION channel2_3 -- The third partition range is ('7', '9').
)UPDATE GLOBAL INDEX;

Alternatively, split the partition by specifying the partition value instead of the partition name.

ALTER TABLE list_sales SPLIT PARTITION FOR ('6') VALUES ('6', '7') INTO
(
    PARTITION channel2_1, -- The first partition range is ('6', '7').
    PARTITION channel2_2  -- The second partition range is ('8', '9').
) UPDATE GLOBAL INDEX;