ORA-14516: subpartition corrupt. all rows do not fall within subpartition bounds ORACLE 报错 故障修复 远程处理

文档解释

ORA-14516: subpartition corrupt. all rows do not fall within subpartition bounds

Cause: The subpartition contains rows which should really be in some other subpartition. Possibly due to an exchange subpartition without validation

Action: Delete rows in subpartition which do not qualify

官方解释

常见案例

正常处理步骤为：1.首先要分析导致ORA-14516的行的属性和分区的键值；2.根据上述分析发现的结果，找出哪些分区键值不匹配；3.在子分区中添加足够的新分区，以容纳要插入的行；4.也可以将表数据转换为与分区键值兼容的格式。