Home » Server Options » Replication » Materialized View
Materialized View [message #29387] Sat, 28 February 2004 03:55 Go to next message
M.V.GOPAL REDDY
Messages: 12
Registered: February 2004
Junior Member
Hello friends

 

 Please tell me how to create Materialized view, and diff between view, mat view

 

regards

M.V.Gopal Reddy

 

Report message to a moderator

Re: Materialized View [message #29394 is a reply to message #29387] Sun, 29 February 2004 00:52 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
Senior Member
A view is just a way of viewing tables. It is a logical table and is sort of like saving a query. A materialized view actually creates a physical object based on a query. Please click on the links below for Oracle on-line documentation:



[/list]

Report message to a moderator

Re: Materialized View [message #29398 is a reply to message #29394] Sun, 29 February 2004 04:47 Go to previous messageGo to next message
M.V.GOPAL REDDY
Messages: 12
Registered: February 2004
Junior Member
ThanQ Mr. Barbara Boehmer

Report message to a moderator

Re: Materialized View [message #29400 is a reply to message #29387] Sun, 29 February 2004 05:35 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
in addition to what Barbara said , --> View

-Thiru

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: Replication View
Next Topic: Create view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 13:44:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.