Re: view re-creation

From: Ram Raman <veeeraman_at_gmail.com>
Date: Fri, 17 Jul 2009 00:47:06 -0500
Message-ID: <effc058d0907162247v7886ae4dq92046665d39354ca_at_mail.gmail.com>



Thanks all. I had set the long to 100,000 before. That was not the issue.

The issue was the text was displayed in 80 character lines with text getting cut and the remaining part of the view definitions in the following line and so on. This is irrespective of the linesize or long setting.

On Thu, Jul 16, 2009 at 7:02 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:

> Set long 10000
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ram Raman
> *Sent:* Thursday, July 16, 2009 7:49 PM
> *To:* Gus Spier
> *Cc:* ORACLE-L
> *Subject:* Re: view re-creation
>
>
>
>
>
> Sorry, that did not help. Same results.
>
>
>
>
> I cannot remember all of the settings off the top of my head, but you
> cannot go too far wrong with:
>
> SET SERVEROUTPUT ON SIZE 1000000 LINES 132 PAGES 0
>
> R,
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 17 2009 - 00:47:06 CDT

Original text of this message