Invalid objects


<br />
SET LINESIZE  145<br />
SET PAGESIZE  9999</p>
<p>clear columns<br />
clear breaks<br />
clear computes</p>
<p>column owner           format a25         heading 'Owner'<br />
column object_name     format a30         heading 'Object Name'<br />
column object_type     format a20         heading 'Object Type'<br />
column status          format a10         heading 'Status'</p>
<p>break on owner skip 2 on report<br />
compute count label ""               of object_name on owner<br />
compute count label "Grand Total: "  of object_name on report</p>
<p>SELECT<br />
    owner<br />
  , object_name<br />
  , object_type<br />
  , status<br />
FROM dba_objects<br />
WHERE status <> 'VALID'<br />
ORDER BY owner, object_name<br />
/<br />

SET LINESIZE  145
SET PAGESIZE  9999

clear columns
clear breaks
clear computes

column owner           format a25         heading 'Owner'
column object_name     format a30         heading 'Object Name'
column object_type     format a20         heading 'Object Type'
column status          format a10         heading 'Status'

break on owner skip 2 on report
compute count label ""               of object_name on owner
compute count label "Grand Total: "  of object_name on report

SELECT
    owner
  , object_name
  , object_type
  , status
FROM dba_objects
WHERE status <> 'VALID'
ORDER BY owner, object_name
/