VIEW: SYS.UTL_RECOMP_ALL_OBJECTS

Source

View Text - Preformatted

SELECT o.obj#, u.name owner, o.name objname, o.type#, o.namespace, o.status,
          o.defining_edition edition_name
   FROM "_ACTUAL_EDITION_OBJ" o, user$ u
   WHERE     o.owner# = u.user#
         AND o.remoteowner IS NULL
         AND (   o.type# IN (1, 2, 4, 5, 6, 7, 8, 9, 11, 12, 14,
                             22, 23, 24, 29, 32, 33, 42, 43, 46, 59, 62)
              OR (o.type# = 13 AND o.subname IS NULL AND
                  NOT REGEXP_LIKE(o.name, 'SYS_PLSQL_[[:alnum:]]+_[[:alnum:]]+_[12]')))
         AND (BITAND(o.flags, 128) = 0)
   UNION ALL
   SELECT s.obj#, a.ext_username owner, s.name objname, s.type#, s.namespace,
          s.status, e.name edition_name
   FROM  obj$ s, user$ a, obj$ e
   WHERE     s.remoteowner IS NULL
         AND s.type# = 88
         AND s.status = 5
         AND s.owner# = a.user#
         AND a.spare2 = e.obj#

View Text - HTML Formatted

SELECT O.OBJ#
, U.NAME OWNER
, O.NAME OBJNAME
, O.TYPE#
, O.NAMESPACE
, O.STATUS
, O.DEFINING_EDITION EDITION_NAME
FROM "_ACTUAL_EDITION_OBJ" O
, USER$ U
WHERE O.OWNER# = U.USER#
AND O.REMOTEOWNER IS NULL
AND ( O.TYPE# IN (1
, 2
, 4
, 5
, 6
, 7
, 8
, 9
, 11
, 12
, 14
, 22
, 23
, 24
, 29
, 32
, 33
, 42
, 43
, 46
, 59
, 62) OR (O.TYPE# = 13
AND O.SUBNAME IS NULL AND NOT REGEXP_LIKE(O.NAME
, 'SYS_PLSQL_[[:ALNUM:]]+_[[:ALNUM:]]+_[12]')))
AND (BITAND(O.FLAGS
, 128) = 0) UNION ALL SELECT S.OBJ#
, A.EXT_USERNAME OWNER
, S.NAME OBJNAME
, S.TYPE#
, S.NAMESPACE
, S.STATUS
, E.NAME EDITION_NAME
FROM OBJ$ S
, USER$ A
, OBJ$ E
WHERE S.REMOTEOWNER IS NULL
AND S.TYPE# = 88
AND S.STATUS = 5
AND S.OWNER# = A.USER#
AND A.SPARE2 = E.OBJ#