Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange behavior with SQLPLUS (Oracle)
Did you 'set linesize nnn' and 'set trimspool'?
-- Ron Reidy Oracle DBA Roger Redford wrote:Received on Wed Jan 15 2003 - 09:51:06 CST
> 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...
>