Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 12 down vote accepted

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.

share|improve this answer
    
wow, great answer! Are you oracle? –  paweloque Mar 24 '11 at 16:30
    
do you know any resources describing this in more detail? (especially about the refresh groups)? –  paweloque Mar 24 '11 at 16:30
2  
@lewap - Added a link to some documentation –  Justin Cave Mar 24 '11 at 16:39
4  
The job is also optional as materialized views can be refreshed on commit or on demand as the referenced documentation indicates. –  Leigh Riffel Mar 24 '11 at 17:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.