Example - Adding a Subpartition to a LIST/RANGE Partitioned Table v13
The following example adds a RANGE
subpartition to the list-partitioned sales
table. The sales
table was created with the command:
The sales
table has three partitions, named europe, asia
, and americas
. Each partition has two range-defined subpartitions.
The following command adds a subpartition named europe_2013
.
After invoking the command, the table includes a subpartition named europe_2013
.
Note
When adding a new range subpartition, the subpartitioning rules must specify a range that falls after any existing subpartitions.