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

文档解释

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.也可以将表数据转换为与分区键值兼容的格式。

你可能感兴趣的