RE: view re-creation

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 16 Jul 2009 20:02:05 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F1AF9A4D8_at_AAPQMAILBX02V.proque.st>



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 Thu Jul 16 2009 - 19:02:05 CDT

Original text of this message