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