Replication interval is smaller, there are few update conflicts - Oracle Replication

Discussion

• Nirja Shah   -Posted on 18 Sep 15
  - If two sites change the same data within the data replication interval, you have an update conflict.
  
  - The more frequently you propagate your changes (that is, the smaller your replication interval), the fewer update conflicts will occur.
  
  - Oracle detects update conflicts by comparing the old values for a row from the remote (or propagating) site with the current values at the local (or receiving) site.
  
  - If they are the same, no conflict has occurred and the new values are applied at the local site.
  
  - If they are different, a conflict is detected.

➨ Post your comment / Share knowledge