DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: What is A MVIEW?

  1. 08-22-2003, 11:47 AM #1
    djhex
    djhex is offline Junior Member
    Join Date
    Aug 2003
    Posts
    9

    What is A MVIEW?

    Can somebody please explain me what a Materialized View is? I ve never heard of it. thanks
    add me to your messenger

    perrohijueputa@hotmail.com
    Reply With Quote Reply With Quote
  2. 08-22-2003, 12:05 PM #2
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    The answer to this question, and many of the other questions you have posted, can be found at http://tahiti.oracle.com. Pick a version, do a search. Really, it's pretty easy to do.
    Reply With Quote Reply With Quote
  3. 08-22-2003, 12:48 PM #3
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    http://www.engin.umich.edu/caen/wls/.../a90237/mv.htm

    Cheers!
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
  4. 08-22-2003, 01:05 PM #4
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    Great, so now we're relying on U of Mich for documentation? Why stop there when there are hundreds of other places that have posted Oracle docs on their websites? It would have been more useful to tell djhex to install the documentation locally or go buy a friggin' book and look it up for himself. Which, by the way djhex, why don't you go buy a friggin' book and look this up for yourself?
    Last edited by marist89; 08-22-2003 at 01:16 PM.
    Reply With Quote Reply With Quote
  5. 08-22-2003, 01:38 PM #5
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    A Materialized View is like a snapshot of your data derived from other table(s). Its just like a table whose data comes from other tables/views.

    Generally materialized views are used in data warehousing environment where they can be of great help for performance gains. You have to explicitly refresh the data in MV regularly based on your requirements.

    read http://technet.oracle.com/docs/produ.../a76994/mv.htm
    -- Dilip
    Reply With Quote Reply With Quote
  6. 08-23-2003, 05:31 PM #6
    Veen
    Veen is offline Junior Member
    Join Date
    Aug 2003
    Posts
    16
    MViews can also be used in Replication environment as like Snapshots in a distributed environment .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width