Re: spooling statement problem

"Kirk W. Conrad" <kwconrad_at_mdanderson.org> wrote in message news:9detfq$i99$1_at_oac2.hsc.uth.tmc.edu...
> I'm spooling derived statements to a file that I want to execute in
 sqlplus.
> The problem is that the statement I'm using is spooling to the file also
> along with the spool off statement. I get the following in the spooled
> file. All I want is the analyze statements. Is there some sqlplus
 variable
> I can use to prevent this?
>
> SQL> select 'analyze table ' || owner || '.' || table_name || ' list
> chained rows;'
> 2 from dba_tables
> 3 where chain_cnt <> 0 and (chain_cnt/num_rows) > .1
> 4 and owner not in ('SYS','SYSTEM');
> analyze table xxx.yyyyyy list chained rows;
> analyze table ggg.wwww list chained rows;
>
> SQL> spool off
>
> Thanks.
> Kirk
>

try:-

set feedback off;
set pagesize 0;
set line 255;
set trimspool on;
set termout off;
spool ... Received on Thu May 10 2001 - 16:50:45 CDT