
select owner,table_name,to_char(last_analyzed,'ddmmyyyy hh24:mi:ss'),num_rows
from dba_tables 
where owner = 'ICAG' and table_name like '%'
order by owner,table_name;

select owner,table_name,to_char(last_analyzed,'ddmmyyyy hh24:mi:ss'),num_rows
from dba_indexes
where owner = 'ICAG' and table_name like '%'
order by owner,table_name,index_name;
