Set pages 0
Spool e:\analize1.sql
Select 'Select ' || ''' Analyze Table ' || owner || '.' || table_name || ' Compute statistics;''' || ' from dual ' ||
' Where ' || num_rows || ' > (Select count(*) + 2000 from ' || owner || '.' || table_name || ');'
from dba_tables
;
spool off
spool e:\analize2.sql
@e:\analize1.sql
spool off
@e:\analize2.sql
Set pages 50