The titles table was repartitioned by range on the total_sales column in “Changing the partitioning type”. This example changes the partition key but not the partitioning type.
alter table titles partition by range(pubdate)
(q1 values <= ("3/31/2006"),
q2 values <= ("6/30/2006"),
q3 values <= ("9/30/2006"),
q1 values <= ("12/31/2006"))
You must drop all indexes before changing the partitioning
key.
