DBA Data[Home] [Help]

VIEW: SYS.DBA_REPRESOLUTION

Source

View Text - Preformatted

select
    sname,
    oname,
    decode(conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    reference_name,
    sequence_no,
    method_name,
    function_name,
    priority_group,
    resolution_comment
from  system.repcat$_resolution
View Text - HTML Formatted

SELECT SNAME
, ONAME
, DECODE(CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, REFERENCE_NAME
, SEQUENCE_NO
, METHOD_NAME
, FUNCTION_NAME
, PRIORITY_GROUP
, RESOLUTION_COMMENT FROM SYSTEM.REPCAT$_RESOLUTION