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

There is a error happen in crotab:

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

Cause:

1.create new partition high value is 1500768000000

sql as belows :

select to_char((TO_DATE(trunc(sysdate+14,'d')) - TO_DATE('1970-01-01 00','YYYY-MM-DD HH24'))*(24*60*60*1000)) as  count_high_value from dual;

add partition:PART_201729

1500768000000

2.now exist partition  high value is 1504224000000 (PART_201708) . it is higher .

PART_201708

1504224000000

PART_201707

1501545600000

Solution:

so i guess the new partition will create ok in sep (201709).

ps:

1。

 select table_name,partition_name,high_value  from dba_tab_partitions where table_name in ('TD') and partition_name='PART_201708'

  select count(*) from ddata.d_DAILY_INVENTORY partition (PART162);