ORA-14080: partition cannot be split along the specified high bound ORACLE 报错 故障修复 远程处理

文档解释

ORA-14080: partition cannot be split along the specified high bound

Cause: User attempted to split a partition along a bound which either collates higher than that of the partition to be split or lower than that of a partition immediately preceding the one to be split

Action: Ensure that the bound along which a partition is to be split collates lower than that of the partition to be split and higher that that of a partition immediately preceding the one to be split

ORA-14080 错误表明PARTITION不能沿着指定的高边界被拆分。

官方解释

ORA-14080 可以在执行 ALTER TABLE SPLITPARTIION 语句时发生。该资源名称必须与表空间相同，否则将得到 ORA-14080 错误。

常见案例

当您尝试使用ALTER TABLE SPLITPARTITION 语句来拆分某个分区时，如果指定的高边界值不能被精确的表示时，那么您将得到ORA-14080 错误。

正常处理方法及步骤

1.确定高边界的值无误

2.确保指定的高边界值可以被精确的表示

3.使用 UPDATE 子句来定义一个新的值

4.使用 ALTER TABLE SPLIT PARTITION 语句来拆分分区