Materialized View – Page 2 – Make DBA Life Easy

How to Pause and Resume Oracle Materialized View Refresh on Commit

A client wants to temporarily stop terabytes Oracle materialized views refresh for application issue diagnosing, and then resume the refresh without invalidating the materialized views.

SOLUTION

Read more of this content when you subscribe today.

How to Create and Maintain Materialized View

Here we will demonstrate how to create a materialized view with fast refresh, make a materialized view updateable, materialized view partitions, SYSDATE usage in materialized view creation and materialized view log shrink etc.

Create Source Table and Materialized View Log
Create Materialized View for Read Only
Create Materialized View for Update
Create Partitioned Materialized View
Explain Materialized View
Shrink Materialized View Log
Check Materialized View Refresh Status

Read more of this content when you subscribe today.