VIEW: SYS.EXU7SNAPU

Source

View Text - Preformatted

SELECT sowner, u.user#, vname, tname, mview, mowner, master, mlink,
       decode(can_use_log, null, 'NO', 'YES'), 
       snaptime, error#, 
       decode(auto_fast, 
              'C', 'COMPLETE', 
              'F', 'FAST', 
              '?', 'FORCE', 
              null, 'FORCE', 'ERROR'), 
       auto_fun, auto_date, query_txt, mod(trunc(flag/2),2), ustrg, uslog
from sys.snap$ s, sys.user$ u
WHERE u.name = s.sowner
AND   UID = u.user#
AND   1 = 0                          /* v7 export of v8 snapshots disallowed */

View Text - HTML Formatted

SELECT SOWNER
, U.USER#
, VNAME
, TNAME
, MVIEW
, MOWNER
, MASTER
, MLINK
, DECODE(CAN_USE_LOG
, NULL
, 'NO'
, 'YES')
, SNAPTIME
, ERROR#
, DECODE(AUTO_FAST
, 'C'
, 'COMPLETE'
, 'F'
, 'FAST'
, '?'
, 'FORCE'
, NULL
, 'FORCE'
, 'ERROR')
, AUTO_FUN
, AUTO_DATE
, QUERY_TXT
, MOD(TRUNC(FLAG/2)
, 2)
, USTRG
, USLOG FROM SYS.SNAP$ S
, SYS.USER$ U WHERE U.NAME = S.SOWNER AND UID = U.USER# AND 1 = 0 /* V7 EXPORT OF V8 SNAPSHOTS DISALLOWED */