VIEW: SYS.DBA_MVIEW_LOGS

Source

View Text - Preformatted

select m.mowner, m.master, m.log, m.trig,
       decode(bitand(m.flag,1), 0, 'NO', 'YES'),
       decode(bitand(m.flag,2), 0, 'NO', 'YES'),
       decode(bitand(m.flag,512), 0, 'NO', 'YES'),
       decode(bitand(m.flag,4), 0, 'NO', 'YES'),
       decode(bitand(m.flag,1024), 0, 'NO', 'YES'),
       decode(bitand(m.flag,16), 0, 'NO', 'YES'),
       decode(bitand(m.flag,16384), 0, 'NO', 'YES'),
       decode(bitand(m.flag,32768), 0, 'NO', 'YES'),
       purge_start, purge_next, last_purge_date,
       last_purge_status, rows_purged,
       decode(bitand(m.flag, 65536), 0, 'NO', 'YES'),
       'NO'
from sys.mlog$ m
union
select ct.source_schema_name, ct.source_table_name, ct.change_table_name,
       ct.mvl_v7trigger,
       decode(bitand(ct.mvl_flag,1), 0, 'NO', 'YES'),
       decode(bitand(ct.mvl_flag,2), 0, 'NO', 'YES'),
       decode(bitand(ct.mvl_flag,512), 0, 'NO', 'YES'),
       decode(bitand(ct.mvl_flag,4), 0, 'NO', 'YES'),
       decode(bitand(ct.mvl_flag,1024), 0, 'NO', 'YES'),
       decode(bitand(ct.mvl_flag,16), 0, 'NO', 'YES'),
       null, null, null, null, null, null, null, null,
       'NO'
from sys.cdc_change_tables$ ct
where bitand(ct.mvl_flag, 128) = 128
union
select u1.name, o2.name, o1.name, null, null, null,
       null, null, null, null, null, null, null, null, null, null, null,
       null, 'YES'
from sys.syncref$_table_info srt, sys.obj$ o1, sys.user$ u1,
     sys.obj$ o2
where o1.owner# = u1.user# and o1.obj# = srt.staging_log_obj#
      and o2.obj# = srt.table_obj#

View Text - HTML Formatted

SELECT M.MOWNER
, M.MASTER
, M.LOG
, M.TRIG
, DECODE(BITAND(M.FLAG
, 1)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 2)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 512)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 4)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 1024)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 16)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 16384)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(M.FLAG
, 32768)
, 0
, 'NO'
, 'YES')
, PURGE_START
, PURGE_NEXT
, LAST_PURGE_DATE
, LAST_PURGE_STATUS
, ROWS_PURGED
, DECODE(BITAND(M.FLAG
, 65536)
, 0
, 'NO'
, 'YES')
, 'NO' FROM SYS.MLOG$ M UNION SELECT CT.SOURCE_SCHEMA_NAME
, CT.SOURCE_TABLE_NAME
, CT.CHANGE_TABLE_NAME
, CT.MVL_V7TRIGGER
, DECODE(BITAND(CT.MVL_FLAG
, 1)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(CT.MVL_FLAG
, 2)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(CT.MVL_FLAG
, 512)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(CT.MVL_FLAG
, 4)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(CT.MVL_FLAG
, 1024)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(CT.MVL_FLAG
, 16)
, 0
, 'NO'
, 'YES')
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'NO' FROM SYS.CDC_CHANGE_TABLES$ CT WHERE BITAND(CT.MVL_FLAG
, 128) = 128 UNION SELECT U1.NAME
, O2.NAME
, O1.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'YES' FROM SYS.SYNCREF$_TABLE_INFO SRT
, SYS.OBJ$ O1
, SYS.USER$ U1
, SYS.OBJ$ O2 WHERE O1.OWNER# = U1.USER#
AND O1.OBJ# = SRT.STAGING_LOG_OBJ#
AND O2.OBJ# = SRT.TABLE_OBJ#