Insert and Updateusing Bulk Operations
575197Aug 15 2011 — edited Aug 15 2011Hi,
We are on 10g (10.2.0.5.0).
We have a batch that will insert/update ~30mm records in each load. The logic is usual if a record exists in target table update it if not insert.
Considering the amount of data to be loaded simple For loop will be very performance intensive. I am looking for a way to do this upsert using bulk operations if possible and want to check if someone can share their experience with similar situations.
Off course all 30mm records will not be loaded in one go, these will be divided into small chunks say 100k.
Thanks
AT