Example - Splitting a RANGE Subpartition v13
The following example splits a range subpartition, redistributing the subpartition's contents between two new subpartitions. The sample table (sales)
was created with the command:
The sales
table has three partitions (europe, asia
, and americas
). Each partition has two range-defined subpartitions that sort the partitions contents into subpartitions by the value of the date
column.
The following command adds rows to each subpartition.
A SELECT
statement confirms that the rows are distributed amongst the subpartitions.
The following command splits the americas_2012
subpartition into two new subpartitions, and redistributes the contents.
After invoking the command, the americas_2012
subpartition has been deleted; in its place, the server has created two new subpartitions (americas_p1_2012
and americas_p2_2012
).
Querying the sales
table demonstrates that the subpartition's contents are redistributed.