Oracle DBA, How To, Error, Cause and Action

ORA-14507: partition corrupt. all rows do not fall within partition bounds

ORA-14507: partition corrupt. all rows do not fall within partition bounds


Cause:


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



Action:


Delete rows in partition which do not qualify

No comments:

Post a Comment

Thanks for your comment.