VIEW: SYS.EXU11SNAP

Source

View Text - Preformatted

SELECT  s.sowner, u.user#, s.vname, s.tname, s.mview, s.mlink, s.mtime,
                DECODE(s.can_use_log, NULL, 'NO', 'YES'), NVL(s.error#, 0),
                DECODE(s.auto_fast, 'C', 'COMPLETE', 'F', 'FAST', '?', 'FORCE',
                       NULL, 'FORCE', 'N', 'NEVER', 'ERROR'),
                s.query_txt, NVL(s.flag, 0),
                /*
                ** have a flag for each snapshot types: rowid, primary key and
                ** updatable for compatibility purpose
                */
                DECODE(BITAND(NVL(s.flag, 0), 16), 16, 1, 0),
                DECODE(BITAND(NVL(s.flag, 0), 32), 32, 1, 0),
                DECODE(BITAND(NVL(s.flag, 0), 2), 2, 1, 0),
                s.ustrg, s.uslog, s.tables, NVL(s.master_version, 0),
                RAWTOHEX(s.lobmaskvec), s.snapshot, NVL(s.snapid, 0),
                s.instsite, NVL(s.flavor_id, 0),
                s.rscn, s.objflag, s.flag2, s.status, s.sna_type_owner,
                s.sna_type_name, s.parent_sowner, s.parent_vname,
                9, 0, s.alias_txt, c.comment$, s.syn_count
        FROM    sys.snap$ s, sys.user$ u, sys.com$ c, sys.obj$ o, sys.tab$ t
        WHERE   u.name = s.sowner AND
                o.owner# = u.user# AND
                o.name = s.vname AND
                o.type# = 2 AND
                o.obj# = t.obj# AND
                (bitand(t.property, 67108864) = 67108864) AND
                o.obj# = c.obj#(+) AND c.col#(+) IS NULL

View Text - HTML Formatted

SELECT S.SOWNER
, U.USER#
, S.VNAME
, S.TNAME
, S.MVIEW
, S.MLINK
, S.MTIME
, DECODE(S.CAN_USE_LOG
, NULL
, 'NO'
, 'YES')
, NVL(S.ERROR#
, 0)
, DECODE(S.AUTO_FAST
, 'C'
, 'COMPLETE'
, 'F'
, 'FAST'
, '?'
, 'FORCE'
, NULL
, 'FORCE'
, 'N'
, 'NEVER'
, 'ERROR')
, S.QUERY_TXT
, NVL(S.FLAG
, 0)
, /* ** HAVE A FLAG FOR EACH SNAPSHOT TYPES: ROWID
, PRIMARY KEY AND ** UPDATABLE FOR COMPATIBILITY PURPOSE */ DECODE(BITAND(NVL(S.FLAG
, 0)
, 16)
, 16
, 1
, 0)
, DECODE(BITAND(NVL(S.FLAG
, 0)
, 32)
, 32
, 1
, 0)
, DECODE(BITAND(NVL(S.FLAG
, 0)
, 2)
, 2
, 1
, 0)
, S.USTRG
, S.USLOG
, S.TABLES
, NVL(S.MASTER_VERSION
, 0)
, RAWTOHEX(S.LOBMASKVEC)
, S.SNAPSHOT
, NVL(S.SNAPID
, 0)
, S.INSTSITE
, NVL(S.FLAVOR_ID
, 0)
, S.RSCN
, S.OBJFLAG
, S.FLAG2
, S.STATUS
, S.SNA_TYPE_OWNER
, S.SNA_TYPE_NAME
, S.PARENT_SOWNER
, S.PARENT_VNAME
, 9
, 0
, S.ALIAS_TXT
, C.COMMENT$
, S.SYN_COUNT
FROM SYS.SNAP$ S
, SYS.USER$ U
, SYS.COM$ C
, SYS.OBJ$ O
, SYS.TAB$ T
WHERE U.NAME = S.SOWNER AND O.OWNER# = U.USER# AND O.NAME = S.VNAME AND O.TYPE# = 2 AND O.OBJ# = T.OBJ# AND (BITAND(T.PROPERTY
, 67108864) = 67108864) AND O.OBJ# = C.OBJ#(+)
AND C.COL#(+) IS NULL