Add Site Column to Table: Step 1

If the target table does not already contain a site column, then you need to add an additional column to your table to record the site's value when a row is inserted or updated. Additionally, you must use the Alter Object subpage of the replicated object property sheet 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, make sure that you use the ALTER_MASTER_REPOBJECT procedure to execute the DDL.

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

1. Complete the steps in Before Configuring Conflict Resolution.

2. Select the table 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 site column to the selected table.

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

   ALTER TABLE oe.orders
   ADD (site_priority VARCHAR2(20))
   

   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.