VIEW: SYS.EXU9SNAPI

Source

View Text - Preformatted

SELECT  s."OWNER",s."OWNERID",s."NAME",s."TABLE_NAME",s."MASTER_VIEW",s."MASTER_LINK",s."MTIME",s."CAN_USE_LOG",s."ERROR",s."TYPE",s."QUERY",s."FLAG",s."ROWID_SNAP",s."PRIMKEY_SNAP",s."UPDATE_SNAP",s."UPDATE_TRIG",s."UPDATE_LOG",s."MASTABS",s."MASVER",s."LOB_VECTOR",s."SNAPSHOT",s."SNAPID",s."INSTSITE",s."FLAVOR_ID",s."RSCN",s."OBJFLAG",s."FLAG2",s."STATUS",s."SNA_TYPE_OWNER",s."SNA_TYPE_NAME",s."PARENT_SOWNER",s."PARENT_VNAME",s."FILE_VER",s."SQL_VER",s."ALIAS_TXT",s."MVIEW_COMMENT"
        FROM    sys.exu9snap s, sys.incexp i, sys.incvid v
        WHERE   s.name = i.name(+) AND
                s.ownerid = i.owner#(+) AND
                /*
                ** Since snapshot also creates a view with the same name,
                ** we need to check for both type view(4) and snapshot(99).
                ** Note: there will be duplicate entry in sys.incexp for this
                */
                NVL(i.type#, 99) in (4, 99) AND
                (s.mtime > i.itime OR
                 NVL(i.expid, 9999) > v.expid)

View Text - HTML Formatted

SELECT S."OWNER"
, S."OWNERID"
, S."NAME"
, S."TABLE_NAME"
, S."MASTER_VIEW"
, S."MASTER_LINK"
, S."MTIME"
, S."CAN_USE_LOG"
, S."ERROR"
, S."TYPE"
, S."QUERY"
, S."FLAG"
, S."ROWID_SNAP"
, S."PRIMKEY_SNAP"
, S."UPDATE_SNAP"
, S."UPDATE_TRIG"
, S."UPDATE_LOG"
, S."MASTABS"
, S."MASVER"
, S."LOB_VECTOR"
, S."SNAPSHOT"
, S."SNAPID"
, S."INSTSITE"
, S."FLAVOR_ID"
, S."RSCN"
, S."OBJFLAG"
, S."FLAG2"
, S."STATUS"
, S."SNA_TYPE_OWNER"
, S."SNA_TYPE_NAME"
, S."PARENT_SOWNER"
, S."PARENT_VNAME"
, S."FILE_VER"
, S."SQL_VER"
, S."ALIAS_TXT"
, S."MVIEW_COMMENT"
FROM SYS.EXU9SNAP S
, SYS.INCEXP I
, SYS.INCVID V
WHERE S.NAME = I.NAME(+) AND S.OWNERID = I.OWNER#(+) AND /* ** SINCE SNAPSHOT ALSO CREATES A VIEW WITH THE SAME NAME
, ** WE NEED TO CHECK FOR BOTH TYPE VIEW(4)
AND SNAPSHOT(99). ** NOTE: THERE WILL BE DUPLICATE ENTRY IN SYS.INCEXP FOR THIS */ NVL(I.TYPE#
, 99) IN (4
, 99) AND (S.MTIME > I.ITIME OR NVL(I.EXPID
, 9999) > V.EXPID)