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

 
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: 9077
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]

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
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:
  


Current Time: Thu Mar 28 21:31:32 CDT 2024