How are materialized views implemented in oracle? I've created a materialized view in oracle. What I now see is a quite normal table with a job. Are materialized views translated into tables & jobs in oracle?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
A materialized view in Oracle is a combination of a structure to hold the data (a table), a job that refreshes the data (a job), and a process that figures out how to refresh the data based on the specified query. This process would generally involve the creation and maintenance of materialized view logs on the base table to track changes so that the materialized view can be refreshed incrementally though that is technically optional. It is also common to organize multiple materialized views into refresh groups so that the materialized views themselves are transactionally consistent with each other.
The Materialized View Concepts and Architecture chapter of the Advanced Replication manual is a good place to start reading up about this sort of thing.