Monday, August 31, 2015

Gather Table Stats on a partition ends in ORA-01422 error

On Oracle databases prior to 11.2, there is a bug where "Gather Table Stats For Partition Results In Error ORA-01422" which can be found via My Oracle Support note ID 2038480.1 and the resolution is to purge duplicate records from multiple WRI$ tables!

No comments:

Post a Comment