I got following script, but I don't how to run at the DB. Any one can help me that can running oracle 8.17 at win2k platform??
set head off
set veri off
set feed off
set echo off
spool c:\temp\openview..sql
select 'analyze table '||owner||'.'||table_name||'
compute statistics for table;'
from dba_tables where table_name like 'OVIPA%';
select 'analyze table '||owner||'.'||table_name||'
compute statistics for all indexes;'
from dba_tables where table_name like 'OVIPA%';
spool off
set head on
set veri on
set feed on
set echo on
@c:\temp\openview.sql