isitdevops.com/databases

— tab_detf.sql
— mdw – show details of selected tables.
set pause on pages 24
clear col
clear breaks
spool tab_detf.lst
col own         form A8
col name        form A25 trunc
col tblspc      form A8  trunc
col clu         form A4
col pctf        form 99
col pctu        form 99
col it          form 99
col mt          form 999
col intl_k      form 9999,999
col next_k      form 9999,999
col pct         form 999
col min_e       form 99999
col max_e       form 99999
col n_rows      form 999,999,999
col n_blocks    form 999,999,999
col empty       form 999,999
col avg_spc     form 9,999
col av_len      form 9999
select
 owner            own
,table_name       name
,tablespace_name  tblspc
,cluster_name     clu
,pct_free         pctf
,pct_used         pctu
,ini_trans        it
,max_trans        mt
,initial_extent/1024   intl_k
,next_extent/1024      next_k
,pct_increase     pct
,min_extents      min_e
,max_extents      max_e
,num_rows         n_rows
,blocks           n_blocks
,empty_blocks     empty
,avg_space        avg_spc
,avg_row_len      av_len
,logging          log
from all_tables
where table_name like upper(nvl(‘&tab_name’,’WHOOPS’)||’%’)
order by table_name,owner
/
clear colu
spool off