Create the Site Priority Group: Step 4

To create the priority group, perform the following steps:

1. Select the column group that you just created from the Name list under the Column Groups section.

2. Click Edit.

   The General subpage of the Edit Column Group page appears.

3. Click Resolution Methods.

   The Resolution Methods subpage of the Edit Column Group page appears.

4. Click Add.

   The Add Resolution Method page appears.

5. Select Site Priority from the Resolution Methods list.

   The Priority Group section appears on the page.

6. Click Create.

   The Create Priority Group page appears.

7. Enter a name for your column group in the Column Group Name field.

8. Select VARCHAR2 for the priority values from the Data Type list.

   The data type must match the data type of the column you plan to use for the priority group. Your site priority group must use the VARCHAR2 data type to store the global name of the site.

9. Enter the first site priority value in the Value field. You must enter a value that matches a value in the site priority column you created. This value should be the global name of one of the replicated databases, such as DBS1.ACME.COM or DBS2.WORLD.

   Start with the value that has the lowest priority. If Oracle detects a conflict, Oracle updates the table whose "priority" column has a lower value using the data from the table with the higher priority value. Therefore, 2 has higher priority than 1.

   If necessary, you can change the priority value by editing the value in the Priority field.

10. Optionally, add a description for the priority group in the Description field.

11. Click OK.

    The Add Resolution Method page reappears.

12. Repeat Steps 6 - 10 until you have added all of the necessary priority values to your priority group.

    As you repeat these steps, notice that the priority value automatically increments by a value of 1 with each additional priority value.