Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On Thu, Jul 16, 2009 at 10:47 PM, Ram Raman <veeeraman@xxxxxxxxx> wrote: > 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. > > OK, now you're making us guess. Personally, I hate guessing. If you can post the *entire* script used to generate the DDL, someone here can help you. Jared