Workaround for ORA-00001: unique constraint violated
610916Oct 1 2008 — edited Oct 1 2008Hi:
Does anybody have a workaround for this?
I am in 10.2.0.3. My sql (insert based on select) gives ORA-00001: unique constraint violated.
I'd like to insert only rows which would not violate the constraint & skip the rows which do.
Maybe this could be done by some trigger which will delete rows from the table (where I am trying to insert) before actual insert...I tried this - did not work for me.
I'm asking for a generic workaround so that even "insert into tab1 select * from tab2;" would work. Suggestions appreciated.