Copy with PK problem in oracle 9i

Hi all,

  I try to copy 5 records from table target to table source with the same structure by using insert. However, from table source there's 1 PK is the same with table target so it return with error and do nothing. If I eliminate that duplicate PK it copy sucessfully.

  Is there anyway that I can copy to another table when it see the duplicate PK it just skip that PK and move to the next one? (I disable the trigger because I want to reserve the same PK number)

Thanks

David Received on Thu Feb 27 2003 - 14:20:37 CST