Concepts and Architecture Question: Download Oracle Architecture and Concepts PDF
Tell me what is the difference between materialized view and snapshot?
Answer:
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.
| Previous Question | Next Question |
| Explain what is Public Database Link? | Explain what is an Index Segment? |