VIEW: SYS.DBA_MVIEW_LOG_FILTER_COLS

Source

View Text - Preformatted

select mowner, master, colname from sys.mlog_refcol$
union
select ct.source_schema_name, ct.source_table_name, cc.column_name
from sys.cdc_change_tables$ ct, sys.cdc_change_columns$ cc
where cc.change_table_obj# = ct.obj#
  and bitand(ct.mvl_flag, 128) = 128
  and cc.column_name not in
    ('RSID$','XIDUSN$','XIDSLT$','XIDSEQ$','OPERATION$',
     'CSCN$','COMMIT_TIMESTAMP$','SOURCE_COLMAP$','TARGET_COLMAP$',
     'USERNAME$', 'TIMESTAMP$', 'ROW_ID$','SYS_NC_OID$')

View Text - HTML Formatted

SELECT MOWNER
, MASTER
, COLNAME
FROM SYS.MLOG_REFCOL$ UNION SELECT CT.SOURCE_SCHEMA_NAME
, CT.SOURCE_TABLE_NAME
, CC.COLUMN_NAME FROM SYS.CDC_CHANGE_TABLES$ CT
, SYS.CDC_CHANGE_COLUMNS$ CC WHERE CC.CHANGE_TABLE_OBJ# = CT.OBJ#
AND BITAND(CT.MVL_FLAG
, 128) = 128
AND CC.COLUMN_NAME NOT IN ('RSID$'
, 'XIDUSN$'
, 'XIDSLT$'
, 'XIDSEQ$'
, 'OPERATION$'
, 'CSCN$'
, 'COMMIT_TIMESTAMP$'
, 'SOURCE_COLMAP$'
, 'TARGET_COLMAP$'
, 'USERNAME$'
, 'TIMESTAMP$'
, 'ROW_ID$'
, 'SYS_NC_OID$')