Previous |
Next |
Perform the following steps to create the priority group:
Select the column group that you just created from the Name list under the Column Groups section.
Click Edit.
The General subpage of the Edit Column Group page appears.
Click Resolution Methods.
The Resolution Methods subpage of the Edit Column Group page appears.
Click Add.
The Add Resolution Method page appears.
Select Site Priority from the Resolution Methods list.
The Priority Group section appears on the page.
Click Create.
The Create Priority Group page appears.
Enter a name for your column group in the Column Group Name field.
Select the data type 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. You specify this column later in the procedure.
Enter the first priority value in the Value field. You must enter a value that matches a value in the column you selected.
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.
Optionally, add a description for the priority group in the Description field.
Click OK.
The Add Resolution Method page reappears.
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.