More than one new partition at a time and dismantling one partition
ALTER TABLE emp_part ADD PARTITION
PARTITION p4 VALUES LESS THAN (35000)
PARTITION p5 VALUES LESS THAN (40000)
same
ALTER TABLE emp_part DROP PARTITIONS p4,p5
ALTER TABLE emp_part TRUNCATE PARTITONS p4,p5
Drop and truncation
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)
