Gather statistics fails with : (ORA-00001: Violation UNIQUE-constraint (SYS.I_MON_MODS_ALL$_OBJ).
My gather stat jobs fails every night with a unique constraint violation.
*** 2009-10-29 22:00:04.781
ORA-12012: Error in task 433600.
ORA-00001: Violation Unique-Constraint (ORA-00001: Violation UNIQUE-constraint (SYS.I_MON_MODS_ALL$_OBJ).
ORA-06512: in "SYS.DBMS_STATS", line 20078
ORA-06512: in "SYS.DBMS_STATS", line 20407
Has anyone an idea ?
Thank you,
Kristof