REM RMINC_BigTablesAndIndexes.sql
REM Copyright 2006, All Rights Reserved, Reed-Matthews, Inc.

REM Searches for big tables and indexes in the database.  Some of these 
REM big tables may be pruned by some of the Purge or Delete programs
REM seeded by Oracle, though you'll need to research and test to be
REM sure.

select substr(OWNER,1,15) "OWNER",
substr(segment_NAME,1,30) "NAME",
substr(segment_type,1,12)"TYPE",
bytes "BYTES",
extents "EXTENTS"
  from sys.dba_segments where
  segment_type in ('INDEX','TABLE') and 
  bytes > 100000000 and owner not in ('SYS',’SYSTEM’) 
order by bytes desc;