S
Satya Prasad
Guest
1. why\how did this occur, is this beacuse we didn't enable the Database Triggers at the same time as the Bulkload ? and is this something we should do for future tables ? Yes. This might be the reason for out of sync. The right sequence is, enable database triggers and then bulk-load the tables. Once bulk-load completes then turn on the replication threads to process the updates in the replqueue. 2. The missing 500K is probably the difference between the Bulkload starting and the 7 days it took to finish, so that would imply that the Record count is taken at the start of the bulkload ? so everythin after that should be an update ? and should the Table trigger not have transferred the 500K ? This 500k is the difference between the time-gap of enable trigger vs bulk-load. More the gap among them will cause more records to be out of sync. 3. the most important, how do we rectify this, would stating a Bulkload again for that table be a risk ? as it is 70 millions records in the table I would not want to have truncate the Target Table and start again from scratch especially just for 500K records I am not aware of any solution to rectify this other than bulk-load of that particular table. However, if you can know those 500k rowid’s then you can rectify by creating replqueue records for those 500k records. Hope this Helps, Satya
Continue reading...
Continue reading...