VIEW: SYS.USER_MVIEW_LOGS

Source

View Text - Preformatted

select s."LOG_OWNER",s."MASTER",s."LOG_TABLE",s."LOG_TRIGGER",s."ROWIDS",s."PRIMARY_KEY",s."OBJECT_ID",s."FILTER_COLUMNS",s."SEQUENCE",s."INCLUDE_NEW_VALUES",s."PURGE_ASYNCHRONOUS",s."PURGE_DEFERRED",s."PURGE_START",s."PURGE_INTERVAL",s."LAST_PURGE_DATE",s."LAST_PURGE_STATUS",s."NUM_ROWS_PURGED",s."COMMIT_SCN_BASED",s."STAGING_LOG" from dba_mview_logs s, sys.user$ u
where s.log_owner = u.name
  and u.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT S."LOG_OWNER"
, S."MASTER"
, S."LOG_TABLE"
, S."LOG_TRIGGER"
, S."ROWIDS"
, S."PRIMARY_KEY"
, S."OBJECT_ID"
, S."FILTER_COLUMNS"
, S."SEQUENCE"
, S."INCLUDE_NEW_VALUES"
, S."PURGE_ASYNCHRONOUS"
, S."PURGE_DEFERRED"
, S."PURGE_START"
, S."PURGE_INTERVAL"
, S."LAST_PURGE_DATE"
, S."LAST_PURGE_STATUS"
, S."NUM_ROWS_PURGED"
, S."COMMIT_SCN_BASED"
, S."STAGING_LOG"
FROM DBA_MVIEW_LOGS S
, SYS.USER$ U WHERE S.LOG_OWNER = U.NAME
AND U.USER# = USERENV('SCHEMAID')