VIEW: SYS.EXU81LBSP

Source

View Text - Preformatted

SELECT  /*+ NO_INDEX(i_obj1) +*/
                spo.obj#, o.obj#, o.owner#,
                DECODE(bitand(c.property,1), 0, '"'||c.name||'"', 1, ac.name),
                lspo.subname,
                ts.name, lspo.flags, ts.ts#, lf.file#, lf.block#,
                lspo.dataobj#, lispo.name, lispo.flags, its.name, its.ts#,
                isp.file#, isp.block#, lispo.dataobj#, isp.initrans,
                isp.maxtrans, NVL(c.type#, 0),
                (select NVL(ct.flags, 0) from sys.coltype$ ct
                        where ct.obj# = c.obj# AND ct.intcol# = c.intcol#),
                ts.blocksize, lf.fragflags
        FROM    sys.lobfrag$ lf, sys.indsubpart$ isp, sys.lobcomppart$ lcp,
                sys.partobj$ pobj, sys.obj$ o, sys.col$ c,
                sys.attrcol$ ac, sys.lob$ l,
                sys.obj$ spo, sys.obj$ lspo, sys.obj$ lispo, sys.ts$ its,
                sys.ts$ ts
        WHERE   pobj.obj# = o.obj# AND
                MOD(pobj.spare2, 256) != 0 AND
                o.obj# = c.obj# AND
                c.obj# = l.obj# AND
                c.intcol# = l.intcol# AND
                l.obj# = ac.obj#(+) AND
                l.intcol# = ac.intcol#(+) AND
                l.lobj# = lcp.lobj# AND
                lf.parentobj# = lcp.partobj# AND
                lf.fragobj# = lspo.obj# AND
                lf.tabfragobj# = spo.obj# AND
                lf.indfragobj# = lispo.obj# AND
                lf.indfragobj# = isp.obj# AND
                isp.ts# = its.ts# AND
                lf.ts# = ts.ts# AND
                BITAND(c.property, 32768) != 32768 AND  /* not unused column */
                BITAND(c.property, 256) != 256          /* not sys generated */

View Text - HTML Formatted

SELECT /*+ NO_INDEX(I_OBJ1) +*/ SPO.OBJ#
, O.OBJ#
, O.OWNER#
, DECODE(BITAND(C.PROPERTY
, 1)
, 0
, '"'||C.NAME||'"'
, 1
, AC.NAME)
, LSPO.SUBNAME
, TS.NAME
, LSPO.FLAGS
, TS.TS#
, LF.FILE#
, LF.BLOCK#
, LSPO.DATAOBJ#
, LISPO.NAME
, LISPO.FLAGS
, ITS.NAME
, ITS.TS#
, ISP.FILE#
, ISP.BLOCK#
, LISPO.DATAOBJ#
, ISP.INITRANS
, ISP.MAXTRANS
, NVL(C.TYPE#
, 0)
, (SELECT NVL(CT.FLAGS
, 0)
FROM SYS.COLTYPE$ CT
WHERE CT.OBJ# = C.OBJ#
AND CT.INTCOL# = C.INTCOL#)
, TS.BLOCKSIZE
, LF.FRAGFLAGS
FROM SYS.LOBFRAG$ LF
, SYS.INDSUBPART$ ISP
, SYS.LOBCOMPPART$ LCP
, SYS.PARTOBJ$ POBJ
, SYS.OBJ$ O
, SYS.COL$ C
, SYS.ATTRCOL$ AC
, SYS.LOB$ L
, SYS.OBJ$ SPO
, SYS.OBJ$ LSPO
, SYS.OBJ$ LISPO
, SYS.TS$ ITS
, SYS.TS$ TS
WHERE POBJ.OBJ# = O.OBJ# AND MOD(POBJ.SPARE2
, 256) != 0 AND O.OBJ# = C.OBJ# AND C.OBJ# = L.OBJ# AND C.INTCOL# = L.INTCOL# AND L.OBJ# = AC.OBJ#(+) AND L.INTCOL# = AC.INTCOL#(+) AND L.LOBJ# = LCP.LOBJ# AND LF.PARENTOBJ# = LCP.PARTOBJ# AND LF.FRAGOBJ# = LSPO.OBJ# AND LF.TABFRAGOBJ# = SPO.OBJ# AND LF.INDFRAGOBJ# = LISPO.OBJ# AND LF.INDFRAGOBJ# = ISP.OBJ# AND ISP.TS# = ITS.TS# AND LF.TS# = TS.TS# AND BITAND(C.PROPERTY
, 32768) != 32768
AND /* NOT UNUSED COLUMN */ BITAND(C.PROPERTY
, 256) != 256 /* NOT SYS GENERATED */