Example: Splitting a lIST subpartition v16
This example splits a list subpartition, redistributing the subpartition's contents between two new subpartitions.
The sample table sales
was created with the command:
The sales
table has partitions named first_half_2012
and second_half_2012
. Each partition has two range-defined subpartitions that distribute the partition's contents into subpartitions based on the value of the country
column.
This command adds rows to each subpartition:
A SELECT
statement confirms that the rows are correctly distributed among the subpartitions:
This command splits the p2_americas
subpartition into two new subpartitions and redistributes the contents.
After the command is invoked, the p2_americas
subpartition is deleted. In its place, the server creates the subpartitions p2_us
and p2_canada
:
Querying the sales
table shows that the content of the p2_americas
subpartition was redistributed: