title: Unique key constraint error while inserting in SQL
body: <p>There are two table <code>x_ass_table</code> and <code>i_ass_table</code> :</p>
  
  <p>I am inserting data from <code>x_ass_table</code> with 13000 records to i_ass_table:</p>
  
  <p>There is a unique constraint in <code>i_ass_table</code></p>
  
  <pre><code> CREATE UNIQUE INDEX i_ass_table_pk ON i_ass_table(ASSIGNMENT_NUMBER,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,EFFECTIVE_LATEST_CHANGE)
  
  insert into i_ass_table select * from x_ass_table;
  </code></pre>
  
  <p>I am getting a unique constraint error </p>
  
  <pre><code>00001. 00000 -  "unique constraint (%s.%s) violated"
  *Cause:    An UPDATE or INSERT statement attempted to insert a duplicate key.
             For Trusted Oracle configured in DBMS MAC mode, you may see
             this message if a duplicate entry exists at a different level.
  *Action:   Either remove the unique restriction or do not insert the key.
  </code></pre>
  
  <p>This has to be an error with the data. But how do i check which data is courrupt or duplicate out of 13000 records</p>