oracle删除和拆分表分区

--删除历史分区

alter table tincome drop partition P_HIS UPDATE GLOBAL INDEXES;  

--拆分当前分区

alter table tincome split partition P_CUR at('20200930') into (partition P_HIS,partition P_CUR) update global indexes;

-- 下面这条”新建表分区“会报错

ORA-14074: partition bound must collate higher than that of the last partition

这个错误的原因是因为分区时已经有了最大的分区，所以无法继续分区。因为p_cur分区已经是 less than (maxvalue)

alter table tincome add
  partition P_HIS values less than (maxvalue)
    tablespace TA4
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 8M
      next 1M
      minextents 1
      maxextents unlimited
    );