Loading ...
Sorry, an error occurred while loading the content.
 

RE: [toad] Idea: Display materialized view query

Expand Messages
  • Peltier, Burt V SEPCO
    Seems that a materialized view should show up under the folder for snapshots because snapshots became materialized views in Oracle8i. In Oracle8i, when a
    Message 1 of 2 , Feb 1, 2002
      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.'.


      Burt Peltier
      Sr. Systems Analyst / Oracle DBA


      -----Original Message-----
      From: Don [mailto:dondealy@...]
      Sent: Thursday, January 31, 2002 9:39 PM
      To: toad@yahoogroups.com
      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"
      browser tab.

      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.


      -- Don


      To unsubscribe, send email to toad-unsubscribe@egroups.com
      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/
    Your message has been successfully submitted and would be delivered to recipients shortly.