12C新特性:添加多个表分区

ALTER TABLE t_whs_p ADD
PARTITION p6 VALUES LESS THAN (60),
PARTITION p7 VALUES LESS THAN (70),
PARTITION p8 VALUES LESS THAN (80),
PARTITION p9 VALUES LESS THAN (90),
PARTITION p10 VALUES LESS THAN (100);

Related Posts