We are getting ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated
While running DBMS_STATS.GATHER_TABLE_STATS we are getting the following error
EXEC DBMS_STATS.GATHER_TABLE_STATS(ownname => tab_owner, tabname => 'y_table method_opt => 'FOR ALL COLUMNS SIZE AUTO', degree => DBMS_STATS.DEFAULT_DEGREE, cascade=> DBMS_STATS.AUTO_CASCADE, no_invalidate => DBMS_STATS.AUTO_INVALIDATE)
Error report -
ORA-00604: error occurred at recursive SQL level 1
ORA-06512: at "SYS.DBMS_STATS", line 36905
ORA-06512: at "SYS.DBMS_STATS", line 36539
ORA-06512: at "SYS.DBMS_STATS", line 35445
ORA-06512: at "SYS.DBMS_STATS", line 14821
ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated
ORA-06512: at "SYS.DBMS_STATS", line 1704
ORA-06512: at "SYS.DBMS_STATS", line 14492