This content has been marked as final. Show 5 replies
SET PAGESIZE 50000
select owner, object_type, count(*) from dba_objects
where owner NOT IN ('SYS','SYSTEM')
group by owner, object_type order by owner;
Edited by: hitgon on Jan 2, 2013 6:06 PM
This works and is almost the same as I postet above. Do anyone know how I could get it all on one row for each schema?