DBA Data[Home] [Help]

VIEW: SYS.KU$_TABLE_EST_VIEW

Source

View Text - Preformatted

SELECT  t.cols, t.rowcnt, t.avgrln, u.name, o.name
        FROM    SYS.OBJ$ O, SYS.TAB$ T, SYS.USER$ U
        WHERE   t.obj# = o.obj# AND
                o.owner# = u.user# AND
                (UID IN (0, o.owner#) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))
View Text - HTML Formatted

SELECT T.COLS
, T.ROWCNT
, T.AVGRLN
, U.NAME
, O.NAME
FROM SYS.OBJ$ O
, SYS.TAB$ T
, SYS.USER$ U
WHERE T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND (UID IN (0
, O.OWNER#) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))