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: Roger Redford <dba_222_at_yahoo.com>
Date: 15 Jan 2003 07:46:46 -0800
Message-ID: <a8c29269.0301150746.2dd7ac5d@posting.google.com>


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:46:46 CST

Original text of this message

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