Oracle 9i Conflict Resolution
•Conflict 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.
Docsity.com
