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

lfree發表於2021-04-18

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

--//連結
--//重複測試:

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部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2768588/,如需轉載,請註明出處,否則將追究法律責任。

相關文章