For Example>
ALTER TABLE TB_SMS_HISTORY
PARTITION BY RANGE (TO_DAYS(REG_DATE))
(
PARTITION p001 VALUES LESS THAN (TO_DAYS(‘2015-12-01’)),
PARTITION p002 VALUES LESS THAN (TO_DAYS(‘2016-01-01’)),
PARTITION p003 VALUES LESS THAN (TO_DAYS(‘2016-02-01’)),
….
..
};
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));