Several conflict-resolution routines provided with Enterprise Edition can be automatically
used to resolve replication conflicts. An administrator can simply choose which
conflict-resolution strategy he wishes to use for a particular replication. For updates
that may affect a column or groups of columns, standard resolution choices include
the following:
Overwrite and discard value
Used when there is a single master (originating) site for new values to update
current values at destination sites.
Minimum and maximum value
Minimum compares the new value at the originating site and the current value at
the destination and applies the new value only if it is less than the current value.
Maximum compares the new value at the originating site and the current value
at the destination and applies the new value only if it is greater than the current
value.
312 | Chapter 13: Oracle Distributed Databases and Distributed Data
Earliest and latest timestamp value (with designation of a column of type DATE)
Earliest dictates that when there are multiple new values, the value used for
updates will be in the row with the earliest timestamp.
Pages:
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678