ORA-14074: partition bound must collate higher tha

ORA-14074: partition bound must collate higher than that of the last partition错误解决

在使用alter table TAB_STAT_DAY_COMPANY add PARTITION p201001 values less than (to_date('2010-01-01','yyyy-mm-dd'));

增加分区时,我想大家碰到的最多的错误就是ORA-14074: partition bound must collate higher than that of the last partition.

因为表上已经有了pmaxvalue分区,这个时候oracle是不直接允许增加分区的. 而是通过拆分分区实现,只要只用下列语句增加分区就不会发生该错误.

 

ALTER TABLE TAB_STAT_DAY_COMPANY SPLIT PARTITION pmaxvalue at (to_date('2010-01-01','yyyy-mm-dd')) INTO (PARTITION p201001, PARTITION pmaxvalue);