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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
