ttitle left skip 1 "QUANTIDADE DOS OBJETOS DO USUÁRIO" skip 2
SET lines 125 pages 300
clear columns
COL owner       for a20
COL object_type for a20
SELECT  
	owner,
	object_type,
	status,
	count(*) "TOTAL"
FROM
 	dba_objects 
WHERE
 	owner IN ('PONTO', 'CAUSO', 'CAUSU', 'TELEMAT', 'USUTCP01', 'USUTCP02', 'USUTCP03')
--, 'CCACONTAB', 'CCAMKT', 'CCAAPLIC')
GROUP BY 
	owner, object_type, status
ORDER BY 
	owner, object_type;
ttitle off;