DBA Data[Home] [Help]
Skip to content

VIEW: SYS.USER_REPCONFLICT

Source

View Text - Preformatted

select
    r.oname,
    decode(r.conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    r.reference_name
from  system.repcat$_conflict r, user$ u
where r.sname = u.name
and   u.user# = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT R.ONAME
, DECODE(R.CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, R.REFERENCE_NAME FROM SYSTEM.REPCAT$_CONFLICT R
, USER$ U WHERE R.SNAME = U.NAME AND U.USER# = USERENV('SCHEMAID')