VIEW: SYS.EXU9LBP

Source

View Text - Preformatted

SELECT  /*+ NO_INDEX(i_obj1) +*/
                po.obj#, o.obj#, o.owner#,
                DECODE(bitand(c.property,1), 0, '"'||c.name||'"', 1, ac.name),
                lpo.subname,
                ts.name, lpo.flags, lf.chunk, lf.pctversion$, lf.fragflags,
                lf.fragpro, lf.ts#, lf.file#, lf.block#, lpo.dataobj#,
                lipo.name, lipo.flags, its.name, its.ts#, ip.file#, ip.block#,
                lipo.dataobj#, ip.initrans , ip.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
        FROM    sys.indpart$ ip, sys.obj$ o, sys.col$ c,
                sys.attrcol$ ac, sys.obj$ lpo,
                sys.lob$ l, sys.partobj$ pobj, sys.ts$ ts, sys.obj$ lipo,
                sys.lobfrag$ lf, sys.obj$ po, sys.ts$ its
        WHERE   pobj.obj# = o.obj# AND
                MOD(pobj.spare2, 256) = 0 AND
                o.obj# = c.obj# AND
                c.obj# = l.obj# AND
                l.obj# = ac.obj#(+) AND
                l.intcol# = ac.intcol#(+) AND
                c.intcol# = l.intcol# AND
                l.lobj# = lf.parentobj# AND
                lf.fragobj# = lpo.obj# AND
                lf.tabfragobj# = po.obj# AND
                lf.indfragobj# = lipo.obj# AND
                lf.indfragobj# = ip.obj# AND
                ip.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 */
      UNION ALL                                                      /* PIOT */
        SELECT  /*+ NO_INDEX(i_obj1) +*/
                ipt.obj#, o.obj#, o.owner#,
                DECODE(bitand(c.property,1), 0, '"'||c.name||'"', 1, ac.name),
                lpo.subname,
                ts.name, lpo.flags, lf.chunk, lf.pctversion$, lf.fragflags,
                lf.fragpro, lf.ts#, lf.file#, lf.block#, lpo.dataobj#,
                lipo.name, lipo.flags, its.name, its.ts#, ip.file#, ip.block#,
                lipo.dataobj#, ip.initrans , ip.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
        FROM    sys.indpart$ ipt, sys.indpart$ ip, sys.ind$ i, sys.tabpart$ tp,
                sys.obj$ o, sys.col$ c, sys.attrcol$ ac,
                sys.obj$ lpo, sys.lob$ l,
                sys.partobj$ pobj, sys.ts$ ts, sys.obj$ lipo, sys.lobfrag$ lf,
                sys.ts$ its
        WHERE   i.obj# = ipt.bo# AND
                tp.bo# = i.bo# AND
                tp.part# = ipt.part# AND
                pobj.obj# = o.obj# AND
                MOD(pobj.spare2, 256) = 0 AND
                o.obj# = c.obj# AND
                c.obj# = l.obj# AND
                l.obj# = ac.obj#(+) AND
                l.intcol# = ac.intcol#(+) AND
                c.intcol# = l.intcol# AND
                l.lobj# = lf.parentobj# AND
                lf.fragobj# = lpo.obj# AND
                lf.tabfragobj# = tp.obj#  AND
                lf.indfragobj# = lipo.obj# AND
                lf.indfragobj# = ip.obj# AND
                ip.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) +*/ PO.OBJ#
, O.OBJ#
, O.OWNER#
, DECODE(BITAND(C.PROPERTY
, 1)
, 0
, '"'||C.NAME||'"'
, 1
, AC.NAME)
, LPO.SUBNAME
, TS.NAME
, LPO.FLAGS
, LF.CHUNK
, LF.PCTVERSION$
, LF.FRAGFLAGS
, LF.FRAGPRO
, LF.TS#
, LF.FILE#
, LF.BLOCK#
, LPO.DATAOBJ#
, LIPO.NAME
, LIPO.FLAGS
, ITS.NAME
, ITS.TS#
, IP.FILE#
, IP.BLOCK#
, LIPO.DATAOBJ#
, IP.INITRANS
, IP.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
FROM SYS.INDPART$ IP
, SYS.OBJ$ O
, SYS.COL$ C
, SYS.ATTRCOL$ AC
, SYS.OBJ$ LPO
, SYS.LOB$ L
, SYS.PARTOBJ$ POBJ
, SYS.TS$ TS
, SYS.OBJ$ LIPO
, SYS.LOBFRAG$ LF
, SYS.OBJ$ PO
, SYS.TS$ ITS
WHERE POBJ.OBJ# = O.OBJ# AND MOD(POBJ.SPARE2
, 256) = 0 AND O.OBJ# = C.OBJ# AND C.OBJ# = L.OBJ# AND L.OBJ# = AC.OBJ#(+) AND L.INTCOL# = AC.INTCOL#(+) AND C.INTCOL# = L.INTCOL# AND L.LOBJ# = LF.PARENTOBJ# AND LF.FRAGOBJ# = LPO.OBJ# AND LF.TABFRAGOBJ# = PO.OBJ# AND LF.INDFRAGOBJ# = LIPO.OBJ# AND LF.INDFRAGOBJ# = IP.OBJ# AND IP.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 */ UNION ALL /* PIOT */ SELECT /*+ NO_INDEX(I_OBJ1) +*/ IPT.OBJ#
, O.OBJ#
, O.OWNER#
, DECODE(BITAND(C.PROPERTY
, 1)
, 0
, '"'||C.NAME||'"'
, 1
, AC.NAME)
, LPO.SUBNAME
, TS.NAME
, LPO.FLAGS
, LF.CHUNK
, LF.PCTVERSION$
, LF.FRAGFLAGS
, LF.FRAGPRO
, LF.TS#
, LF.FILE#
, LF.BLOCK#
, LPO.DATAOBJ#
, LIPO.NAME
, LIPO.FLAGS
, ITS.NAME
, ITS.TS#
, IP.FILE#
, IP.BLOCK#
, LIPO.DATAOBJ#
, IP.INITRANS
, IP.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
FROM SYS.INDPART$ IPT
, SYS.INDPART$ IP
, SYS.IND$ I
, SYS.TABPART$ TP
, SYS.OBJ$ O
, SYS.COL$ C
, SYS.ATTRCOL$ AC
, SYS.OBJ$ LPO
, SYS.LOB$ L
, SYS.PARTOBJ$ POBJ
, SYS.TS$ TS
, SYS.OBJ$ LIPO
, SYS.LOBFRAG$ LF
, SYS.TS$ ITS
WHERE I.OBJ# = IPT.BO# AND TP.BO# = I.BO# AND TP.PART# = IPT.PART# AND POBJ.OBJ# = O.OBJ# AND MOD(POBJ.SPARE2
, 256) = 0 AND O.OBJ# = C.OBJ# AND C.OBJ# = L.OBJ# AND L.OBJ# = AC.OBJ#(+) AND L.INTCOL# = AC.INTCOL#(+) AND C.INTCOL# = L.INTCOL# AND L.LOBJ# = LF.PARENTOBJ# AND LF.FRAGOBJ# = LPO.OBJ# AND LF.TABFRAGOBJ# = TP.OBJ# AND LF.INDFRAGOBJ# = LIPO.OBJ# AND LF.INDFRAGOBJ# = IP.OBJ# AND IP.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 */