Database Utilities (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center