dba_apply_conflict_columns

The dba_apply_conflict_columns view displays information about conflict handlers on all tables in the database: The important fields of the view are:

• method_name shows the name of the update handler used to resolve conflicts.
   

• resolution_column shows the name of the column used to resolve conflicts.
   

• column_name shows the name of a column in the column list for the update conflict handler.

The following SQL statement shows details of conflict columns:

select object_owner, object_name, method_name,
resolution_column, column_name
from dba_apply_conflict_columns
/

dba_apply_dml_handlers

This view displays information about the DML handlers on all tables in the database. The column USER_PROCEDURE shows the PL/SQL procedure assigned to function as the DML handler. OPERATION_NAME shows the type command such as Delete, Update, Insert. When ERROR_HANDLER is specified as TRUE, the DML handler becomes an Error Handler.