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@xxxxxxxxxxxx>wrote: > Set long 10000 > > > > -Mark > > > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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, > >