Re: sqlplus : How to turn off output to termi

If you are running on a unix platform, I would suggest NOT running your script from within SQLPLUS when spooling large data but run from the unix prompt.

IE: sqlplus -s username/password @yourscript.sql > spooldata.txt

Actually with this method, you should not have a "spool" statement in your script.

If you are not on a unix platform....I'll be looking at responces you receive....

Good luck.

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Sat Mar 08 1997 - 00:00:00 CST