Home » Other » General » VIEWS and materialized views
VIEWS and materialized views [message #351440] Tue, 30 September 2008 19:49 Go to next message
Messages: 7
Registered: August 2008
Junior Member
I read many books,forums, but i could not find the MAIN difference between a VIEW and a MATERIALIZED view. Can any one please help to understand.
I know that,
- a VIEW is a customised representation of data of one or more tables, and which is same as with MATERILAZED view.
- VIEW occupies space, where M.View doesnot occupy.
- VIEW actually doesn't contain data, it contains.

But, i could not understand the MAIN difference, why we use M.VIEW, if it is same as VIEW.

I'm sure that i am wrong, can anybody please help me out.
Thanks in advance.
Re: VIEWS and materialized views [message #351478 is a reply to message #351440] Wed, 01 October 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All these questions are answered in Database Concepts and most of them in chapter 1 "Introduction to the Oracle Database":
Views: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref74
MViews: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref183


[Updated on: Wed, 01 October 2008 01:15]

Report message to a moderator

Re: VIEWS and materialized views [message #360036 is a reply to message #351440] Wed, 19 November 2008 05:28 Go to previous message
Messages: 106
Registered: December 2005
Senior Member
View does not store any data and it does not occupy any space, it pulls the data from base tables on which it is bulit, at the time when it is called, it will not be a segement in database.
where as Mview occupies space and stores the data, it is also bulit on a table, from which it takes data, also the data in mview generally gets refreshed from the base table. The mview is a segment. it is generally used as a summary table or to store data from multiple tables in a data warehouse, where the result will be faster as compared to a table. Where as view is generally used when you want to provide access to only particular columns of a table and view can be read only.
Previous Topic: OracleVM
Next Topic: PLease give me answer of following questions?
Goto Forum:

Current Time: Sat Jun 10 18:41:25 CDT 2023