SQL> set pages  9999 
SQL> set lines  100 
SQL> col segment_name format a30
SQL> col owner format a30
SQL> select segment_name, owner, count(*)
from dba_extents
where segment_type = 'TABLE'
group by segment_name, owner
having count(*) >  5 ;
 
SEGMENT_NAME		       OWNER				COUNT(*)
 ------------------------------ ------------------------------ ----------
 
ARGUMENT$		       SYS				        8 
COMPANIES_50_STATES	       TRAIN				       22 
CUST_GENUITY		       TRAIN				        8 
CUST_INTER		       TRAIN				        6 
CUST_QWEST		       TRAIN				        7 
EMPS			       TRAIN				       30 
FREEL_TABLE		       TRAIN				       11 
.....
.....