DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error ORA-00001: unique constraint

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Error ORA-00001: unique constraint

    hello everyone...

    I am trying tochange the domain of a table from abc.com to xyz.com and i am getting this error...

    ---------------------
    ORA-00001: unique constraint (LYRIS8.IX_MEMBERS_LIST_EMAILLC) violated
    ------------------------

    This table already has 970 + records with abc.com and i am trying to update it to xyz.com...

    Where am i doing wrong ?...here is the SQL...

    update members_ set domain_ = replace (domain_, 'abc.com','xyz.com');


    thanks
    Ron

  2. #2
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    You have a duplicate record after updating on whatever columns are constrained UNIQUE by IX_MEMBERS_LIST_EMAILLC.

    As lyris8, try:

    Code:
    SELECT column_name 
    FROM user_constraints
    WHERE constraint_name = 'IX_MEMBERS_LIST_EMAILLC'
    ORDER BY position
    My bet would be that domain_ plus some other column is required to be unique, and you already have a record for abc.com plus the other column among the 970 records already in the table for abc.com.

    John

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