-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|