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 -> How can i see full query of snapshot?

How can i see full query of snapshot?

From: sagi <sagi_at_bpath.com>
Date: 15 Jan 2002 05:08:05 -0800
Message-ID: <1e9ede0a.0201150508.a677b3@posting.google.com>

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? Received on Tue Jan 15 2002 - 07:08:05 CST

This message: [ Message body ]
Next message: macknox: "ORA-01026: multiple buffers of size > 4000 in the bind list (Shrink wrap software)"
Previous message: Stephan Bressler: "SSX lock"
Next in thread: Sybrand Bakker: "Re: How can i see full query of snapshot?"
Reply: Sybrand Bakker: "Re: How can i see full query of snapshot?"

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

Original text of this message

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