ORA-14628: specification of bounds is inconsistent with LIST method ORACLE 报错 故障修复 远程处理

文档解释

ORA-14628: specification of bounds is inconsistent with LIST method

Cause: An operation such as ALTER TABLE SPLIT|ADD SUBPARTITION specified bounds that were inconsistent with List subpartitioning method

Action: Specify VALUES/subpartition descriptions correctly for SPLIT/ADD of List subpartitions

ORA-14628 错误表示您的语句指定的范围与 LIST 方法不一致。

官方解释

ORA-14628: specified bounds are inconsistent with LIST method

指定索引范围可以用三种方法：BOUND，RANGE 或 LIST。 必须使用特定方法以进行在任何给定范围中检索行的查询。

例：

查询中按列