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