If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hello,
I need to add a unique constraint on table U_SMCSHIPPING column SERVICER_LN_NUM . I know there are presently rows that violates this constraint (meaning, there are duplicate rows).
I used the following statement and got an error message.

Why I am getting this error msg when I'm explicitely telling it not to validate. All I want is to prevent future duplications.
Please help. it's very urgent.
Oracle 8i version 8.1.6 Enterprise Edition.

Thanks for the quick reply but...

Thanks for the quick reply but if I use Disable, will future duplicate inserts be prevented? I think the table will allow duplicate rows.
Also, I went ahead and created it with the disable clause as suggested and tried to enable it with the novalidate option:
ALTER TABLE EMPOWER.U_SMCSHIPPING ENABLE NOVALIDATE CONSTRAINT CHASE_NUM_UNIQUE;

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