Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Suntan Newsgroups: comp.databases.oracle.misc,comp.os.vms Subject: Re: sqlplus : How to turn off output to terminal ? Date: Wed, 11 Oct 2017 21:46:00 -0000 (UTC) Organization: A noiseless patient Spider Lines: 26 Message-ID: References: <754ece62-b02f-42cf-8f5e-8306a929a810@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Wed, 11 Oct 2017 21:46:00 -0000 (UTC) Injection-Info: reader02.eternal-september.org; posting-host="c2f8f83af40ce1ffe0a18fb8e59cccbd"; logging-data="9398"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/I4AJ0cLU8yc/QoRs4DJ3g" User-Agent: Pan/0.132 (Waxed in Black) Cancel-Lock: sha1:M52bvoCAoACI822rq2aSJXrqBvA= Xref: csiph.com comp.databases.oracle.misc:1032 comp.os.vms:70952 On Fri, 06 Oct 2017 14:41:42 -0700, suhong.it wrote: > On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan wrote: >> How do I turn off output to terminal sqlplus from a select statement >> when I am spooling the result to a text file ? >> >> I have tried echo off, feedback off etc. but nothing seems to work. The >> problem is not easy to handle when the result is huge and I am over a >> modem connection. >> >> Thanks. >> >> Atif Khan >> aak2@ra.msstate.edu > > > This is interesting topic. I found it today. hope it is useful. sqlplus > "%usr_name%/%pass%@%db" @sqlscript.sql > suppressed.out As Suhong said, run it as a batch command with redirected output. If you need to, you can check on progress by connecting periodically and doing "tail -f suppressed.out". If you don't know if a result will be huge, connect via a utility or system that can junk terminal output yet still allow a "spool wanted.out". In an academic environment you may have VMS. Connect through VMS and type Ctrl-O (a second one resumes o/p).