Migrate Oracle Materialized Views with AWS DMS and Fast Refresh
Database Blog
This article explains how to migrate Oracle Materialized Views to AWS using AWS DMS with Fast Refresh and materialized view logs to enable efficient incremental CDC replication instead of costly full reloads.
- Configure Oracle Materialized Views with Fast Refresh option and MV logs to track row-level changes incrementally
- Use traditional Oracle join syntax (not ANSI) and include ROWID columns in MV SELECT statements for Fast Refresh compatibility
- Schedule incremental MV refresh jobs using DBMS_SCHEDULER to process only delta changes between refresh cycles
- Create AWS DMS Full Load + CDC task to replicate only incremental changes, reducing replication time by over 90% for 20M-row datasets
- Optimize performance by creating indexes on ROWID columns, gathering MV log statistics, and setting _mv_refresh_use_stats parameter
This approach eliminates full-reload overhead, achieves near real-time replication, and scales efficiently for large datasets without requiring additional software beyond native Oracle features.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
2026
2026
2026
2024
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.