Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: Reasons for unique constraint error

    hi,
    I try to insert some records in a table and this well-known message appears: "ORA-00001: unique constraint (xxx_xxx.proj_01_UK) violated". Therefore, I know that each row that I try to insert is unique and not already in the table. Is there another reason for wich Oracle could call this error?

    thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Exclamation

    Also with UPDATE if trying to change the unique key to an already existing key.

Posting Permissions

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