Word distributed is a little ambiguous here. So, what I recommend you to study is going deeped in anything of a mview that can be classified as distributed as:
- Partitioned Materialized Views
- Nested Materialized Views
- Materialized Views over DB Link
- Refresh Groups to sync MViews
Path to Documentation:
Oracle Database Data Warehousing Guide -> Basic/Advanced Materialized Views
Oracle Database Data Warehousing Guide -> Basic/Advanced Query Rewrite
Oracle Database SQL Language Reference -> CREATE MATERIALIZED VIEW (LOG)
Oracle Database Advanced Replication -> 3 Materialized View Concepts and Architecture (extremely advanced)
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!