Re: Strange behavior with SQLPLUS (Oracle)

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 15 Jan 2003 19:22:47 -0000
Message-ID: <3e270cce_2@mk-nntp-1.news.uk.worldonline.com>

"Roger Redford" <dba_222_at_yahoo.com> wrote in message news:a8c29269.0301150746.2dd7ac5d_at_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?
>

Have you tried:

set trimspool on?

Regards,
Paul Received on Wed Jan 15 2003 - 13:22:47 CST

This message: [ Message body ]
Next message: Frank: "Re: JSP Check Error when installing 11.5.7 Corrected"
Previous message: Paul Brewer: "Re: What is the work attire of an Oracle DBA?"
In reply to: Roger Redford: "Re: Strange behavior with SQLPLUS (Oracle)"
Next in thread: Roger Redford: "Re: Strange behavior with SQLPLUS (Oracle)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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