column owner format a20
column table_name format a25
column partition_name format a25
column subpartition_name format a25
column MB format 999999
column MB_EST format 999999
column temporary format a5

set ver off

SET FEED OFF
set HEADING off
SELECT '---------TABLA + SEGMENTOS--------' FROM DUAL;
SET FEED ON
set HEADING on

select t.owner,t.table_name,min(t.pct_free) pct_free, min(t.AVG_ROW_LEN) avg_row,min(t.num_rows) num_rows,min(t.AVG_ROW_LEN)*min(t.num_rows)/1024/1024 MB_EST,sum(s.bytes)/1024/1024 MB,sum(s.blocks) blocks,to_char(min(t.last_analyzed),'ddmmyyyy hh24:mi:ss') last_analyzed,
min(t.temporary) temporary
from dba_tables t, dba_segments s
where t.owner = s.owner
and t.table_name = s.segment_name
and t.owner like upper('&1')
and t.table_name like upper('&2')
group by t.owner,t.table_name
order by t.owner,t.table_name;

