Timestamp

The earliest timestamp and latest timestamp methods are variations on the minimum and maximum value methods. To use the timestamp method, you must designate a column in the replicated table of type DATE. When an application updates any column in a column group, a trigger also updates the value of the designated timestamp column with the local SYSDATE.

When you use the earliest timestamp conflict resolution method, the oldest changes are always applied. When you user the latest timestamp conflict resolution method, the most recent changes are always applied.

There are several elements needed to make timestamp conflict resolution work well:

• Synchronized time settings between computers.

• Timestamp field and a trigger to automatically record timestamp.