OCM 11g Preparation - Configure and manage distributed materialized views

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 👍!

Leave a Reply

Your email address will not be published.