【 使用环境 】测试环境
【问题描述】
执行 alter table tab_abc add partition p1 values less than (TO_DATE(‘2024-01-01 00:00:00’,‘SYYYY-MM-DD HH24:MI:SS’,‘NLS_CALENDAR=GREGORIAN’))
报错误信息 partition bound must collate higher than that of the last partition
该如何人解决？
新添加的分区范围必须比最后一个分区的范围要大。如
obclient [TEST]> show create table t1;
±------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TABLE | CREATE TABLE |
±------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| T1 | CREATE TABLE “T1” (
“LOG_ID” NUMBER(38),
“LOG_DATE” DATE DEFAULT sysdate CONSTRAINT “T1_OBNOTNULL_1688960757651160” NOT NULL ENABLE
) COMPRESS FOR ARCHIVE REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by range(log_date)
(partition PART1 values less than (TO_DATE(’ 2020-02-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)),
partition PART2 values less than (TO_DATE(’ 2020-03-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)),
partition PART3 values less than (TO_DATE(’ 2023-12-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))) |
±------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.008 sec)
obclient [TEST]> alter table t1 add partition part4 values less than (to_date(‘2022-12-01’,‘YYYY-MM-DD’));
ORA-14074: partition bound must collate higher than that of the last partition
obclient [TEST]> alter table t1 add partition part4 values less than (to_date(‘2024-12-01’,‘YYYY-MM-DD’));
Query OK,0 rows affected.