I have this situation and I'm trying to think of the best way to solve it. I have a database, say DB-A, with a table T-A that has 2 fields - OID and PID. This table has close to 1million rows. Now due to some other issue, the PIDs of most of the rows were incorrectly set to 0 and this was found only after a couple of days.

I have a backup from 2 days back, say DB-B, and I'm thinking of updating DB-A with matching entries from DB-B. So what would be the best way to do this ? I have this in mind:

1. Create a .NET app that gets rows from DB-B and updates matching ones in DB-A. Not sure if this will work because of the large no of rows. Maybe will need individual commits under a scoped transaction.
	2. Create a .NET to generate an Oracle SQLloader file from DB-B and load into DB-A

Your thoughts are greatly appreciated...

thanks
Sunit