VIEW: SYS.UTL_RECOMP_INVALID_ALL

Source

View Text - Preformatted

SELECT "OBJ#","OWNER","OBJNAME","TYPE#","NAMESPACE","STATUS","EDITION_NAME" FROM utl_recomp_all_objects
     WHERE status IN (4, 5, 6)
       AND obj# NOT IN (SELECT obj# FROM utl_recomp_compiled)

View Text - HTML Formatted

SELECT "OBJ#"
, "OWNER"
, "OBJNAME"
, "TYPE#"
, "NAMESPACE"
, "STATUS"
, "EDITION_NAME"
FROM UTL_RECOMP_ALL_OBJECTS
WHERE STATUS IN (4
, 5
, 6)
AND OBJ# NOT IN (SELECT OBJ#
FROM UTL_RECOMP_COMPILED)