Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange behavior with SQLPLUS (Oracle)

Re: Strange behavior with SQLPLUS (Oracle)

From: Ron Reidy <rereidy_at_indra.com>
Date: Wed, 15 Jan 2003 08:51:06 -0700
Message-ID: <3E25836A.8040803@indra.com>


Did you 'set linesize nnn' and 'set trimspool'?

--
Ron Reidy
Oracle DBA

Roger Redford wrote:

> I really noticed this symptom when I did spool. I set the linesize
> to 32000. For a few thousand short rows, I had 70 megs of output.
> Most of the output was blanks. When using more, pages and pages of
> blanks for each line of output.
>
> Any ideas how to fix it?
>
>
> marist89 <member15835_at_dbforums.com> wrote in message news:<2386749.1042562390_at_dbforums.com>...
>
>>Hmmm. Spool your output to a file (with termout off, echo off, etc.) to >>see if you get the same results. View the output file from both your >>workstatation and your neighbors...
>
Received on Wed Jan 15 2003 - 09:51:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US