chakri m, September 18, 2015 - 2:38 pm UTC
A reader, September 18, 2015 - 4:24 pm UTC
Isn't streams deprecated in favor for Golden Gate ?
September 18, 2015 - 11:47 pm UTC
chakri m, September 18, 2015 - 4:45 pm UTC
Thanks for the response.
We are doing update on the source and the streams should take care of the replication in target.
As the data is not consitent in source and target, we are seeing the conflicts.
The real issue here is, even though only one column is updated, all the old values are coming in the LCR.
If the old values are not matching with the target data, its erroring out as apply error. I think there is some thing to do with supplemental logging, which is adding all the columns as old values in the LCR even though they are not modified.
dbms_stream_adm.delete_column has to be used at the target db in the conflict handler.
If we can avoid having all the columns as Old values in LCR it will be better while applying the stream.