eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: SYS.EXU81TTS

Source

View Text - Preformatted


SELECT  NVL(t$.dataobj#, t$.obj#), o$.name, o$.owner#, NVL(t$.tab#, 0),
                NVL(t$.bobj#, 0), ts$.name, t$.spare1
        FROM    sys.tab$ t$, sys.obj$ o$, sys.ts$ ts$
        WHERE   t$.obj# = o$.obj# AND
                t$.ts# = ts$.ts# AND
                BITAND(o$.flags, 128) != 128 AND       /* Recycle bin object */
                BITAND(t$.property, 64+512+8192) = 0    /* Not nested or IOT */
      UNION ALL                                   /* 1st Partition is simple */
        SELECT  t$.obj#, o$.name, o$.owner#, NVL(t$.tab#, 0), NVL(t$.bobj#, 0),
                ts$.name, t$.spare1
        FROM    sys.tab$ t$, sys.obj$ o$, sys.ts$ ts$,
                (SELECT  bo#,
                         MIN(ts#) KEEP (DENSE_RANK FIRST ORDER BY part#) ts#
                FROM     sys.tabpart$
                GROUP BY bo#) tp1$
        WHERE   t$.obj# = o$.obj# AND
                t$.obj# = tp1$.bo# AND
                tp1$.ts# = ts$.ts# AND
                BITAND(o$.flags, 128) != 128 AND
                BITAND(t$.property, 64+512+8192) = 0
      UNION ALL                           /* 1st Partition is subpartitioned */
        SELECT  t$.obj#, o$.name, o$.owner#, NVL(t$.tab#, 0), NVL(t$.bobj#, 0),
                ts$.name, t$.spare1
        FROM    sys.tab$ t$, sys.obj$ o$, sys.ts$ ts$,
                (SELECT  tcp$.bo#,
                         MIN(tsp$.ts#) KEEP
                           (DENSE_RANK FIRST ORDER BY
                             tcp$.part#, tsp$.subpart#) ts#
                FROM     sys.tabcompart$ tcp$, sys.tabsubpart$ tsp$
                WHERE    tcp$.obj# = tsp$.pobj#
                GROUP BY tcp$.bo#) tcp1$
        WHERE   t$.obj# = o$.obj# AND
                t$.obj# = tcp1$.bo# AND
                tcp1$.ts# = ts$.ts# AND
                BITAND(o$.flags, 128) != 128 AND       /* recycle bin object */
                BITAND(t$.property, 64+512+8192) = 0
      UNION ALL                                        /* Unpartitioned IOTs */
        SELECT  i$.dataobj#, o$.name, o$.owner#, NVL(t$.tab#, 0),
                NVL(t$.bobj#, 0), ts$.name, t$.spare1
        FROM    sys.tab$ t$, sys.obj$ o$, sys.ts$ ts$, sys.ind$ i$
        WHERE   t$.obj# = o$.obj# AND
                t$.pctused$ = i$.obj# AND /*For IOTs, pctused has index obj# */
                i$.ts# = ts$.ts# AND
                BITAND(o$.flags, 128) != 128 AND       /* recycle bin object */
                BITAND(t$.property, 64+512+8192) = 64
      UNION ALL                                      /* 1st Partition of IOT */
        SELECT  t$.obj#, o$.name, o$.owner#, NVL(t$.tab#, 0), NVL(t$.bobj#, 0),
                ts$.name, t$.spare1
        FROM    sys.tab$ t$, sys.obj$ o$, sys.ts$ ts$,
                (SELECT  bo#,
                         MIN(ts#) KEEP (DENSE_RANK FIRST ORDER BY part#) ts#
                FROM     sys.indpart$
                GROUP BY bo#) ip1$
        WHERE   t$.obj# = o$.obj# AND
                t$.pctused$ = ip1$.bo# AND
                ip1$.ts# = ts$.ts# AND
                BITAND(o$.flags, 128) != 128 AND       /* recycle bin object */
                BITAND(t$.property, 64+512+8192) = 64

View Text - HTML Formatted

SELECT NVL(T$.DATAOBJ#
, T$.OBJ#)
, O$.NAME
, O$.OWNER#
, NVL(T$.TAB#
, 0)
, NVL(T$.BOBJ#
, 0)
, TS$.NAME
, T$.SPARE1
FROM SYS.TAB$ T$
, SYS.OBJ$ O$
, SYS.TS$ TS$
WHERE T$.OBJ# = O$.OBJ# AND T$.TS# = TS$.TS# AND BITAND(O$.FLAGS
, 128) != 128
AND /* RECYCLE BIN OBJECT */ BITAND(T$.PROPERTY
, 64+512+8192) = 0 /* NOT NESTED OR IOT */ UNION ALL /* 1ST PARTITION IS SIMPLE */ SELECT T$.OBJ#
, O$.NAME
, O$.OWNER#
, NVL(T$.TAB#
, 0)
, NVL(T$.BOBJ#
, 0)
, TS$.NAME
, T$.SPARE1
FROM SYS.TAB$ T$
, SYS.OBJ$ O$
, SYS.TS$ TS$
, (SELECT BO#
, MIN(TS#) KEEP (DENSE_RANK FIRST ORDER BY PART#) TS#
FROM SYS.TABPART$ GROUP BY BO#) TP1$
WHERE T$.OBJ# = O$.OBJ# AND T$.OBJ# = TP1$.BO# AND TP1$.TS# = TS$.TS# AND BITAND(O$.FLAGS
, 128) != 128 AND BITAND(T$.PROPERTY
, 64+512+8192) = 0 UNION ALL /* 1ST PARTITION IS SUBPARTITIONED */ SELECT T$.OBJ#
, O$.NAME
, O$.OWNER#
, NVL(T$.TAB#
, 0)
, NVL(T$.BOBJ#
, 0)
, TS$.NAME
, T$.SPARE1
FROM SYS.TAB$ T$
, SYS.OBJ$ O$
, SYS.TS$ TS$
, (SELECT TCP$.BO#
, MIN(TSP$.TS#) KEEP (DENSE_RANK FIRST ORDER BY TCP$.PART#
, TSP$.SUBPART#) TS#
FROM SYS.TABCOMPART$ TCP$
, SYS.TABSUBPART$ TSP$
WHERE TCP$.OBJ# = TSP$.POBJ# GROUP BY TCP$.BO#) TCP1$
WHERE T$.OBJ# = O$.OBJ# AND T$.OBJ# = TCP1$.BO# AND TCP1$.TS# = TS$.TS# AND BITAND(O$.FLAGS
, 128) != 128
AND /* RECYCLE BIN OBJECT */ BITAND(T$.PROPERTY
, 64+512+8192) = 0 UNION ALL /* UNPARTITIONED IOTS */ SELECT I$.DATAOBJ#
, O$.NAME
, O$.OWNER#
, NVL(T$.TAB#
, 0)
, NVL(T$.BOBJ#
, 0)
, TS$.NAME
, T$.SPARE1
FROM SYS.TAB$ T$
, SYS.OBJ$ O$
, SYS.TS$ TS$
, SYS.IND$ I$
WHERE T$.OBJ# = O$.OBJ# AND T$.PCTUSED$ = I$.OBJ#
AND /*FOR IOTS
, PCTUSED HAS INDEX OBJ# */ I$.TS# = TS$.TS# AND BITAND(O$.FLAGS
, 128) != 128
AND /* RECYCLE BIN OBJECT */ BITAND(T$.PROPERTY
, 64+512+8192) = 64 UNION ALL /* 1ST PARTITION OF IOT */ SELECT T$.OBJ#
, O$.NAME
, O$.OWNER#
, NVL(T$.TAB#
, 0)
, NVL(T$.BOBJ#
, 0)
, TS$.NAME
, T$.SPARE1
FROM SYS.TAB$ T$
, SYS.OBJ$ O$
, SYS.TS$ TS$
, (SELECT BO#
, MIN(TS#) KEEP (DENSE_RANK FIRST ORDER BY PART#) TS#
FROM SYS.INDPART$ GROUP BY BO#) IP1$
WHERE T$.OBJ# = O$.OBJ# AND T$.PCTUSED$ = IP1$.BO# AND IP1$.TS# = TS$.TS# AND BITAND(O$.FLAGS
, 128) != 128
AND /* RECYCLE BIN OBJECT */ BITAND(T$.PROPERTY
, 64+512+8192) = 64