What is the differnece between materialized view and snapshot

A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs along with a new terminology, updatable snapshots. With Oracle8.1.6 snapshots started to be used in data warehouse environments so anew terminology materialized view was introduced to address bothdistributed and data warehouse materialized views.
  • Interview Candidate
  • 5
  • 2794

Showing Answers 1 - 5 of 5 Answers

rajat dey

  • Feb 21st, 2006
 

hi,There is no difference only thing is that in oracle 7x it is called snapshot but 8i onwards it is called materialized view.

pravin Karde

  • Sep 25th, 2006
 

sir  i m a M.E. student & i developed a project on Materialized view selection & maintenance.sir for this i urgently need the architecture of Materialized view & its operation. sir pl. help me & send me if  possible.

thanks waiting +vely.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions