ALTERTABLEemp_partADDPARTITION
PARTITIONp4VALUESLESSTHAN(35000),
PARTITIONp5VALUESLESSTHAN(40000);

同样
ALTERTABLEemp_partDROPPARTITIONSp4,p5;
ALTERTABLEemp_partTRUNCATEPARTITONSp4,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);