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
示例:为表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