Home » RDBMS Server » Server Administration » Question About materialzed Views
Question About materialzed Views [message #170149] Tue, 02 May 2006 06:24 Go to next message
tarek_fathi2003
Messages: 6
Registered: March 2006
Location: EGYPT
Junior Member
Dear all
"materialized views allow you to maintain copies of remote data on your local node"
my question is
does a materialized view copy all data each time it is refreshed?
OR it copies only the last updates on the master table?

please help

Report message to a moderator

Re: Question About materialzed Views [message #170155 is a reply to message #170149] Tue, 02 May 2006 06:58 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Depends on the options:

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96520/mv.htm

Search the above link for "refresh options".

Report message to a moderator

Previous Topic: NEED HELP...
Next Topic: error while installing 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:56:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.