[20210418]ORA-14767 Cannot specify this interval with existing high bounds.txt

[20210418]ORA-14767 Cannot specify this interval with existing high bounds.txt --//链接https://www.bobbydurrettdba.com/2021/04/07/ora-14767-when-day-of-month-28-with-interval-partitioning-month-interval/ --//重复测试： 1.环境: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production CREATE TABLE test( RUN_DATE DATE, MY_NBR NUMBER(4) ) PARTITION BY RANGE (RUN_DATE) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH')) (   PARTITION data_p1 VALUES LESS THAN (TO_DATE('01/29/2017', 'MM/DD/YYYY')) ); * ERROR at line 1: ORA-14767: Cannot specify this interval with existing high bounds --//因为2月份可能没有29号。执行如下ok。 CREATE TABLE test( RUN_DATE DATE, MY_NBR NUMBER(4) ) PARTITION BY RANGE (RUN_DATE) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH')) (   PARTITION data_p1 VALUES LESS THAN (TO_DATE('01/28/2017', 'MM/DD/YYYY')) );