DBA Data[Home] [Help]

VIEW: SYS.DBA_REPRESOL_STATS_CONTROL

Source

View Text - Preformatted

select
    sname,
    oname,
    created,
    decode(status,
           1, 'ACTIVE',
           2, 'CANCELLED',
           'UNDEFINED'),
    status_update_date,
    purged_date,
    last_purge_start_date,
    last_purge_end_date
from  system.repcat$_resol_stats_control
View Text - HTML Formatted

SELECT SNAME
, ONAME
, CREATED
, DECODE(STATUS
, 1
, 'ACTIVE'
, 2
, 'CANCELLED'
, 'UNDEFINED')
, STATUS_UPDATE_DATE
, PURGED_DATE
, LAST_PURGE_START_DATE
, LAST_PURGE_END_DATE FROM SYSTEM.REPCAT$_RESOL_STATS_CONTROL