Re: Test if Data for a Field is UNIQUE

On Mon, 23 Jan 2006 20:29:48 -0500, Mark C. Stock wrote:

> are you sure you meant that?
>
> this is possible, but only under the following conditions:
>
> 1) constraint is not enabled or
> 2) constraint is enabled novalidate, and an non-unique index on the PK
> columns already exist prior to enabling the constraint (then the data
> existing prior to enabling the constraint may containt duplicates, but all
> inserts and updates will be validated against the constraint)

This scenario is precisely what I had in mind. Of course, doing data cleanup from the EXCEPTIONS table is always the best option, but you must hate somebody with passion to tell him to browse through 350,000 or so duplicate rows and make business decision about which rows to keep. You can always spice it up with a short deadline. That's called "operating in PHB mode".

-- 
http://www.mgogala.com