spool not to display output

[Muskaan]

Hi All,

I am using spool to redirect table data to a flat file, which in turn will be used by SQL Loader to upload to another database.

I want to know if I can make spool only redirect to file and not show output on screen.

Thanks in advance!

 

[teado]

Toward the beginning of the SQL script:

set termout off

 

[Muskaan]

thanks for your response teado! it works fine now
regards,
M