VIEW: SYS.EXU81SNAPC

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."FILE_VER",s."SQL_VER"
        FROM    sys.exu81snap s, sys.incexp i, sys.incvid v
        WHERE   s.name = i.name(+) AND
                s.ownerid = i.owner#(+) AND
                NVL(i.type#, 99) = 99 AND
                (NVL(i.ctime, TO_DATE('01-01-1900', 'DD-MM-YYYY')) < 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."FILE_VER"
, S."SQL_VER"
FROM SYS.EXU81SNAP S
, SYS.INCEXP I
, SYS.INCVID V
WHERE S.NAME = I.NAME(+) AND S.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 99) = 99 AND (NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR NVL(I.EXPID
, 9999) > V.EXPID)