VIEW: SYS.EXU8CLUC

Source

View Text - Preformatted

SELECT  c."OBJID",c."DOBJID",c."OWNER",c."OWNERID",c."NAME",c."TBLSPACE",c."SIZE$",c."TSNO",c."FILENO",c."BLOCKNO",c."MTIME",c."PCTFREE$",c."PCTUSED$",c."INITRANS",c."MAXTRANS",c."HASHKEYS",c."FUNCTION",c."AVGCHN",c."DEGREE",c."INSTANCES",c."CACHE",c."FUNCTXT",c."FUNCLEN",c."SINGLE_TABLE",c."SQLVER",c."TFLAGS"
        FROM    sys.exu8clu c, sys.incexp i, sys.incvid v
        WHERE   c.name = i.name(+) AND
                c.ownerid = i.owner#(+) AND
                NVL(i.type#, 3) = 3 AND
                (i.itime > NVL(i.ctime, TO_DATE('01-01-1900', 'DD-MM-YYYY')) OR
                 c.mtime > i.itime OR
                 NVL(i.expid, 9999) > v.expid)

View Text - HTML Formatted

SELECT C."OBJID"
, C."DOBJID"
, C."OWNER"
, C."OWNERID"
, C."NAME"
, C."TBLSPACE"
, C."SIZE$"
, C."TSNO"
, C."FILENO"
, C."BLOCKNO"
, C."MTIME"
, C."PCTFREE$"
, C."PCTUSED$"
, C."INITRANS"
, C."MAXTRANS"
, C."HASHKEYS"
, C."FUNCTION"
, C."AVGCHN"
, C."DEGREE"
, C."INSTANCES"
, C."CACHE"
, C."FUNCTXT"
, C."FUNCLEN"
, C."SINGLE_TABLE"
, C."SQLVER"
, C."TFLAGS"
FROM SYS.EXU8CLU C
, SYS.INCEXP I
, SYS.INCVID V
WHERE C.NAME = I.NAME(+) AND C.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 3) = 3 AND (I.ITIME > NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) OR C.MTIME > I.ITIME OR NVL(I.EXPID
, 9999) > V.EXPID)