Oracle 8i Conflict Resolution
Built-in resolution strategies (defined per column-group)
- Add difference between the old and new values of the originating site to the destination site
- Average the value of the current site and the originating site
- Min or max of the two values
- The one with min or max timestamp
- The site or value with maximum priority
- Can apply methods in sequence: e.g., by time , then by priority.
Can call custom procs to log, notify, or resolve the conflict
- Parameters - update’s before/after value and row’s current value
For a given update, if no built-in or custom conflict resolution applies, then the entire transaction is logged.