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

Oracle Error Message

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

Reason for the Error

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

Solution

Delete rows in subpartition which do not qualify