Maybe I was not clear in my previous postings.
The main purpose of me having to create a constraint with enable novalidate option is to ignore the values that are currently present in the table and to only apply the unique constrainst for future updates. This table has millions of rows and thousands of duplicates. (Duplicates were allowed with the old business rule and those records will need to be kept). Now that our business rules have changed, I do not want any duplicate rows to be inserted. How do I create this constraints? I know Oracle has this type of capability. I just can't get it to work.
Thanks,
Robel