Seems that a materialized view should show up under the folder for
'snapshots' because snapshots became materialized views in Oracle8i. In
Oracle8i, when a snapshot is created, the response from Oracle is
'materialized view created.'.
Sr. Systems Analyst / Oracle DBA
From: Don [mailto:dondealy@...
Sent: Thursday, January 31, 2002 9:39 PM
Subject: [toad] Idea: Display materialized view query
I see that TOAD displays a MV as "table", but the browser does not show
the query that makes up the MV. Since I am in the development stages of
MVs right now, there are numerous little changes still taking place. I
would find it very handy to have the query source pop up in the "scripts"
If there are methods in TOAD production 7.2 to see the query, perhaps you
could point me to it. For now, I run queries against the various MVIEWS,
and "double click" on the query column to pop the value of the LONG into
the pop-up editor. This seems like a rather labor intensive method.
To unsubscribe, send email to firstname.lastname@example.org
or go to http://www.egroups.com/list/toad,
and click "Unsubscribe".
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/