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

Home -> Community -> Usenet -> c.d.o.tools -> How do I locate duplicate rows

How do I locate duplicate rows

From: Anthony Valentine <amv_at_sbsalaska.com>
Date: Wed, 29 Nov 2000 16:29:18 -0900
Message-ID: <3A25AD6E.9887FF22@sbsalaska.com> 






Hello All!



I am trying to add a unique constraint to a table, but I get the
following error:



ORA-02299: cannot validate (ORACLE.LOS160MASTER_UK) - duplicate keys
found



Is there any way to get Oracle to tell me which rows contain the
duplicate keys?




Thanks in advance!



Anthony Valentine
Received on Wed Nov 29 2000 - 19:29:18 CST












Original text of this message













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