Example: Splitting a RANGE partition v16
This example divides the q4_2012
partition of the range-partitioned sales
table into two partitions and redistributes the partition's contents. Use this command to create the sales
table:
The table definition creates four partitions: q1_2012
, q2_2012
, q3_2012
, and q4_2012
). This command adds rows to each partition:
A SELECT
statement confirms that the rows are distributed among the partitions:
This command splits the q4_2012
partition into two partitions named q4_2012_p1
and q4_2012_p2
:
A SELECT
statement confirms that the rows were redistributed across the new partitions: