VIEW: SYS.USER_SNAPSHOTS

Source

View Text - Preformatted

select s."OWNER",s."NAME",s."TABLE_NAME",s."MASTER_VIEW",s."MASTER_OWNER",s."MASTER",s."MASTER_LINK",s."CAN_USE_LOG",s."UPDATABLE",s."REFRESH_METHOD",s."LAST_REFRESH",s."ERROR",s."FR_OPERATIONS",s."CR_OPERATIONS",s."TYPE",s."NEXT",s."START_WITH",s."REFRESH_GROUP",s."UPDATE_TRIG",s."UPDATE_LOG",s."QUERY",s."MASTER_ROLLBACK_SEG",s."STATUS",s."REFRESH_MODE",s."PREBUILT" from dba_snapshots s, sys.user$ u
where u.user# = userenv('SCHEMAID')
  and s.owner = u.name

View Text - HTML Formatted

SELECT S."OWNER"
, S."NAME"
, S."TABLE_NAME"
, S."MASTER_VIEW"
, S."MASTER_OWNER"
, S."MASTER"
, S."MASTER_LINK"
, S."CAN_USE_LOG"
, S."UPDATABLE"
, S."REFRESH_METHOD"
, S."LAST_REFRESH"
, S."ERROR"
, S."FR_OPERATIONS"
, S."CR_OPERATIONS"
, S."TYPE"
, S."NEXT"
, S."START_WITH"
, S."REFRESH_GROUP"
, S."UPDATE_TRIG"
, S."UPDATE_LOG"
, S."QUERY"
, S."MASTER_ROLLBACK_SEG"
, S."STATUS"
, S."REFRESH_MODE"
, S."PREBUILT"
FROM DBA_SNAPSHOTS S
, SYS.USER$ U WHERE U.USER# = USERENV('SCHEMAID')
AND S.OWNER = U.NAME