Categories
Data Warehouse Oracle

Oracle Materialized View and Partitioning Gotchas

Materialized Views and Partitioning are two key Oracle features when working with data warehouses. Using them together though can sometimes cause unexpected problems when you need to refresh them, as we found on a recent project. Here’s what happened, reproduced using the SH Sample Schema.

via Rittman Mead Consulting » Blog Archive » Materialized View and Partitioning “Gotchas”.