Unique constraint

From: MARCOTULLI ARMANDO <AMarcotulli_at_eulergroup.com>
Date: Thu, 20 Jun 2002 23:43:20 -0800
Message-ID: <F001.00483D75.20020620234320@fatcity.com>

Hi,

I have some problem regarding the unique constraint and I would like to get some ideas in order to solve a dup key problem.

Let's say I have a table with two columns: col1, col2. In this table there are some rows with the same value for col1.

If I try this:
alter table dwd6 add constraint uq_dwd6
unique (col1)
using index pctfree 0
tablespace dwdix001
exceptions into bad_dwd6;

then I get the following error:
ORA-02299: cannot validate (TSSY01.UQ_DWD6) - duplicate keys found

My doubt is:
If Oracle can't discard duplicate keys when adding a unique constraint for what purpose is it available the "expeception" clause?

Thanks a lot.

Armando
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MARCOTULLI ARMANDO
  INET: AMarcotulli_at_eulergroup.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 21 2002 - 02:43:20 CDT