I don't see the need to recreate the keys. The idea here is to insert a sorted record set where the highest value of a certain field gets inserted first...
I have decided to revisit the query and break it up into smaller return sets. That should take the pressure off the Oracle rollback segment. Unfortunately the throughput of the...
The thing is that I'm not updating anything. I just have a view through a linked server to an Oracle table that selects rows with conditions. It's a straight Insert...