Displaying the Configured Update Conflict Handlers

In a replication environment, update conflict handlers automatically resolve conflicts that occur when the same row is updated at two different databases at nearly the same time. You can use the ALL_APPLY_CONFLICT_COLUMNS data dictionary view to list the update conflict handlers.

To display the configured update conflict handlers: 

1. Open SQL*Plus and connect to the database as the Oracle Streams administrator.

   See Starting SQL*Plus and Connecting to the Database for more information about starting SQL*Plus.

2. Run the following query:

   COLUMN OBJECT_OWNER HEADING 'Table|Owner' FORMAT A5
   COLUMN OBJECT_NAME HEADING 'Table Name' FORMAT A12
   COLUMN METHOD_NAME HEADING 'Method' FORMAT A12
   COLUMN RESOLUTION_COLUMN HEADING 'Resolution|Column' FORMAT A13
   COLUMN COLUMN_NAME HEADING 'Column Name' FORMAT A30
    
   SELECT OBJECT_OWNER, 
          OBJECT_NAME, 
          METHOD_NAME, 
          RESOLUTION_COLUMN, 
          COLUMN_NAME
     FROM ALL_APPLY_CONFLICT_COLUMNS
     ORDER BY OBJECT_OWNER, OBJECT_NAME, RESOLUTION_COLUMN;
   

   The output will be similar to the following:

   Table                           Resolution
   Owner Table Name   Method       Column        Column Name
   ----- ------------ ------------ ------------- ------------------------------
   HR    COUNTRIES    MAXIMUM      TIME          TIME
   HR    COUNTRIES    MAXIMUM      TIME          REGION_ID
   HR    COUNTRIES    MAXIMUM      TIME          COUNTRY_NAME
   HR    DEPARTMENTS  MAXIMUM      TIME          TIME
   HR    DEPARTMENTS  MAXIMUM      TIME          MANAGER_ID
   HR    DEPARTMENTS  MAXIMUM      TIME          LOCATION_ID
   HR    DEPARTMENTS  MAXIMUM      TIME          DEPARTMENT_NAME
   

   The output in this example shows that latest time conflict resolution is configured for the hr.countries and hr.departments tables. When a conflict occurs for any column listed under Column Name, the change with the maximum, or latest, time in the TIME resolution column is used, and the other change is discarded.