Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with unique constraint creation

Problem with unique constraint creation

From: EP <ep_at_plusnet.pl>
Date: Fri, 12 Jul 2002 13:07:15 +0200
Message-ID: <agmd9t$e7i$1@news2.tpi.pl> 





Hi



I've encountered the following problem: I try to create a unique constraint
on the table in which several rows are duplicated with option enable
novalidate (don't check the existing rows but enable the constraint for the
new ones). When I execute the statement I got the ORA-2299 error - cannot
validate (XXXX.YYYY) - duplicate keys found.
What is the problem ?



TIA



EP
Received on Fri Jul 12 2002 - 06:07:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US