Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i see full query of snapshot?

Re: How can i see full query of snapshot?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 Jan 2002 18:39:42 +0100
Message-ID: <5aq84ucf6dp4qdptt60opudp8i5639jgp3@4ax.com> 





On 15 Jan 2002 05:08:05 -0800, sagi_at_bpath.com (sagi) wrote:



>I tried to read the query of a snapshot:

>select query from all_snapshots;

>but i only get part of the query.

>Does anyone can tell me how to do it?





set long <any large arbitrary number>


select query from all_snapshots



Hth



Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Tue Jan 15 2002 - 11:39:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US