Find Schema Details in Oracle

select owner, count(1), object_type from dba_objects group by owner, object_type having owner in
(select username from dba_users where default_tablespace = ‘USERS’) and object_type = ‘TABLE’;