Altering data partitions  Adding partitions to a partitioned table

Chapter 10: Partitioning Tables and Indexes

Changing an unpartitioned table to a partitioned table

This example changes an unpartitioned titles table to a table with three range partitions:

alter table titles partition by range (total_sales)
(smallsales values <= (500) on seg1,
mediumsales values <= (5000) on seg2,
bigsales values <= (25000) on seg3)



Copyright © 2005. Sybase Inc. All rights reserved. Adding partitions to a partitioned table

View this book as PDF