Add a Timestamp Column to Table: Step 1

Complete the following steps to add a timestamp column to the table:

1. Complete the steps in Before Configuring Conflict Resolution.

2. Select the object for which you want to add the conflict resolution method and click Edit.

   The General subpage of the Edit Replicated Object page appears.

3. Click Advanced to display the Enter DDL Text field.

4. Enter the DDL in the Enter DDL Text field to add a timestamp column to the selected table.

   For example, to add a timestamp column named TIME_STAMP to a table named ORDERS in the OE schema, enter the following:

   ALTER TABLE oe.orders
   ADD (time_stamp DATE)
   

   Note: Do not include the terminating semi-colon (;) at the end of the DDL statement.

5. Click Apply to execute the specified DDL at the selected master group.