title: Alter table enable novalidate constraint
body: <p>I am trying to add <code>UNIQUE KEY</code> on a previously existing table with duplicate records by setting <code>ENABLE NOVALIDATE</code>.</p>
  
  <p>But I am getting <code>ORA-02299: cannot validate (my_owner.my_key_UK ) - duplicate keys found</code></p>
  
  <pre><code>ALTER TABLE my_owner.my_table
  ADD CONSTRAINT my_key_UK UNIQUE (ID1,ID2)
  ENABLE NOVALIDATE;
  </code></pre>