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

This message: [ Message body ]
Next message: Allen, Brandon: "RE: %Total Call Time in AWR"
Previous message: Ram Raman: "Re: view re-creation"
In reply to: Ram Raman: "Re: view re-creation"
Next in thread: Ram Raman: "Re: view re-creation"
Reply: Ram Raman: "Re: view re-creation"
Maybe reply: Michael McMullen: "RE: view re-creation"
Maybe reply: Joel.Patterson_at_crowley.com: "RE: view re-creation"
Maybe reply: Jack van Zanen: "RE: view re-creation"

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

Original text of this message