q_nopart_table

admin

1. 
   
2. select s.owner, s.segment_name, round(s.bytes / 1024 / 1024, 0) mb
   
3.   from dba_segments s
   
4. where s.segment_type = 'TABLE'
   
5.    and round(s.bytes / 1024 / 1024, 0) > 4096
   
6.    and s.segment_name not in (select table_name from dba_part_tables)
   
7. order by 3 desc

复制代码