1) Use the MERGE command instead of INSERT. here are some more ideas: http://www.oracle-base.com/articles/10g/dml-error-logging-10gr2.php
On Tue, Sep 11, 2012 at 11:47 AM, imalukegal <[email protected]> wrote: > I have to join several tables together from database #1 and insert the > information to one table in database #2. The problem is that the extracted > data may contain records that are considered duplicate records on the > database #2 table. We are using sql to do the inserts. > We cannot write the contents from the first database to a file, delete the > dups, and then upload to database #2 because the job will run forever > (another developer already tried this approach). We are not allowed to > eliminate the unique constraint on database #2 table. When the duplicate > record is encountered, processing stops, and the oncall programmer is > contacted. > > Ideally, I would like to write the duplicate record to an error file and > continue processing. Is there a way to do this? > > Thank you for any suggestions. > > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
