VIEW: SYS.KU$_PARTITION_EST_VIEW

Source

View Text - Preformatted

SELECT  t.cols, tp.rowcnt, tp.avgrln, u.name, ot.name, op.subname
        FROM    SYS.OBJ$ OT, SYS.OBJ$ OP, SYS.TAB$ T, SYS.TABPART$ TP,
                SYS.USER$ U
        WHERE   tp.obj# = op.obj# AND
                tp.bo# = ot.obj# AND
                ot.type#=2 AND
                t.obj# = tp.bo# AND
                ot.owner# = u.user# AND
                (UID IN (0, ot.owner#) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))

View Text - HTML Formatted

SELECT T.COLS
, TP.ROWCNT
, TP.AVGRLN
, U.NAME
, OT.NAME
, OP.SUBNAME
FROM SYS.OBJ$ OT
, SYS.OBJ$ OP
, SYS.TAB$ T
, SYS.TABPART$ TP
, SYS.USER$ U
WHERE TP.OBJ# = OP.OBJ# AND TP.BO# = OT.OBJ# AND OT.TYPE#=2 AND T.OBJ# = TP.BO# AND OT.OWNER# = U.USER# AND (UID IN (0
, OT.OWNER#) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))