Oracle 12C 一次多个新分区和把一个分区拆了
ALTER TABLE emp_part ADD PARTITION
PARTITION p4 VALUES LESS THAN (35000),
PARTITION p5 VALUES LESS THAN (40000);
同样
ALTER TABLE emp_part DROP PARTITIONS p4,p5;
ALTER TABLE emp_part TRUNCATE PARTITONS p4,p5;
drop和截断
CREATE TABLE emp_part
(eno number(8), ename varchar2(40), sal number (6))
PARTITION BY RANGE (sal)
(PARTITION p1 VALUES LESS THAN (10000),
PARTITION p2 VALUES LESS THAN (20000),
PARTITION p_max VALUES LESS THAN (maxvalue)
);
ALTER TABLE emp_part SPLIT PARTITION p_max INTO
(PARTITION p3 VALUES LESS THAN (25000),
PARTITION p4 VALUES LESS THAN (30000), PARTITION p_max);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/637517/viewspace-2147571/ ，如需转载，请注明出处，否则将追究法律责任。
