You must drop all indexes before changing the partitioning
key.
The titles table was repartitioned by range on the total_sales column in “Changing the partitioning type”. In this example, we change 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"))
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
