-- name       : objchk.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Shows all objects in the database that are invalid and
--              the type and owner of the objects.
-- limitation : Need access to dba_objects
--
-- useage     : SQL> @objchk


set feed off
set linesize 250
set pages 50

spool objchk.lis

col object_name heading "Name" for a30
col object_type heading "Type" for a30
col owner heading "Owner" for a18

select	object_name object_name,
	object_type object_type,
	owner owner
from	dba_objects
where	status='INVALID'
order by owner,object_type;

set lines 79
set pages 24
set feed on

spool off