Database Administration (MOSC)

MOSC Banner

Gather statistics fails with : (ORA-00001: Violation UNIQUE-constraint (SYS.I_MON_MODS_ALL$_OBJ).

edited Nov 12, 2009 11:12PM in Database Administration (MOSC) 2 commentsAnswered
 Hello,

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

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