create or replace procedure get_table_history_stats
is
begin
dbms_stats.gather_schema_stats(ownname=>'HISSAAS');
insert into table_history_stats
select table_name,num_rows,BLOCKS,empty_blocks,AVG_SPACE,avg_row_len,
to_date(to_char(sysdate,'yyyy/mm/dd'),'yyyy/mm/dd')
from user_tables where num_rows<>0;
commit;
end get_table_history_stats;
[@more@]