1.添加删除新的分区
alter table map_device_packages add partition partitions 10; ---10为要增加的分区个数
ALTER TABLE map_device_packages COALESCE PARTITION 6; ---减少分区的个数
2.重建分区
ALTER TABLE table_name REBUILD PARTITION (p0, p1);
3.优化分区
ALTER TABLE table_name OPTIMIZE PARTITION (p0, p1);
4.分析分区
ALTER TABLE table_name ANALYZE PARTITION (p0, p1);
5.检查分区
ALTER TABLE table_name CHECK PARTITION (p0, p1);
阅读(3071) | 评论(0) | 转发(0) |
