[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'))
);

ITPub博客

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

最新文章