DBA Data[Home] [Help]

VIEW: SYS.ALL_APPLY_DML_CONF_HANDLERS

Source

View Text - Preformatted

select h."APPLY_NAME",h."OBJECT_OWNER",h."OBJECT_NAME",h."SOURCE_OBJECT_OWNER",h."SOURCE_OBJECT_NAME",h."COMMAND_TYPE",h."CONFLICT_TYPE",h."METHOD_NAME",h."CONFLICT_HANDLER_NAME",h."RESOLUTION_COLUMN",h."SET_BY"
from all_tables o, all_apply a, DBA_APPLY_DML_CONF_HANDLERS h
where h.object_owner = o.owner and h.object_name = o.table_name and
      a.apply_name = h.apply_name
View Text - HTML Formatted

SELECT H."APPLY_NAME"
, H."OBJECT_OWNER"
, H."OBJECT_NAME"
, H."SOURCE_OBJECT_OWNER"
, H."SOURCE_OBJECT_NAME"
, H."COMMAND_TYPE"
, H."CONFLICT_TYPE"
, H."METHOD_NAME"
, H."CONFLICT_HANDLER_NAME"
, H."RESOLUTION_COLUMN"
, H."SET_BY" FROM ALL_TABLES O
, ALL_APPLY A
, DBA_APPLY_DML_CONF_HANDLERS H WHERE H.OBJECT_OWNER = O.OWNER
AND H.OBJECT_NAME = O.TABLE_NAME AND A.APPLY_NAME = H.APPLY_NAME