export table stats
I issue the following:
set echo off
set feedback off
set linesize 250
spool st04_backup_tab_stats_comp100_01.sql
select 'exec dbms_stats.export_table_stats(ownname=>' || CHR(39)|| owner || CHR(39) ||',' tabname=>|| CHR(39) ||table_name|| CHR(39) ||',' || 'stattab => 'BA
CKUP_STAT_TAB'' ||',' ||'statown => 'WGU''||')'||';'
from dba_tables
where owner='TRITON'
and table_name like '%100'
and num_rows >= 0
and num_rows < 100000
order by table_name;