select owner,object-type,count(*) from dba_objects where owner not in (select username from dba_users where oracle_maintained='Y') group by owner,object_type order by 1;
select owner,object_type,count(*) from dba_objects where owner in ('HR') group by owner,object_type order by 1;
No comments:
Post a Comment