Configuring Timestamp Resolution

If the target table does not already contain a timestamp column, then you need to add an additional column to your table to record the timestamp value when a row is inserted or updated. Additionally, you must use the Alter Object functionality of the replicated object to apply the DDL to the target table.

Simply issuing the DDL in SQL*Plus (or equivalent tool) may cause the replicated object to become invalid. If you prefer to use SQL*Plus to make such an alteration, then make sure that you use the DBMS_REPCAT.ALTER_MASTER_REPOBJECT procedure to execute the altering DDL.

The following are the steps to configure a timestamp resolution:

• Add a Timestamp Column to Table: Step 1

• Create a Timestamp Trigger: Step 2

• Create Column Group: Step 3

• Update Resolution Methods: Step 4