ORA-00001: unique constraint
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-00001: unique constraint

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    ORA-00001: unique constraint

    Hi Gurus,
    I have the following error all over the alert log. I know this happens when there is duplicate entries but really don't know how to fix this with the UPDATE.

    Any help will be appreciated.
    Thanks

    ORA-12012: error on auto execute of job 21
    ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violated
    ORA-06512: at "PERFSTAT.STATSPACK", line 2228
    ORA-06512: at "PERFSTAT.STATSPACK", line 91
    ORA-06512: at line 1
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks
    Davey
    I will try the workaorund
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width