oracle数据库添加和删除分区

示例：为表DJ_JYCPA_MUT按时间添加分区

alter table DJ_JYCPA_MUT add  partition CPA_PART_2019_1 values less than (to_date('2019-02-01 00:00:00','yyyy-mm-dd hh24:mi:ss'));

删除：

ALTER TABLE tablename DROP PARTITION CPA_PART_2019_1