SET VERIFY OFF;
SET LINESIZE 60
COLUMN TIPO FORMAT A25
COLUMN "OBJETOS INVÁLIDOS" FORMAT 999999

SELECT OBJECT_TYPE TIPO,COUNT(*) "OBJETOS INVÁLIDOS"
FROM DBA_OBJECTS
WHERE OWNER=upper('&1')
AND STATUS!='VALID'
GROUP BY OBJECT_TYPE;

SET VERIFY ON;
SET LINESIZE 160
