Refresh Materialized Views (189)

Oracle maintains the data in materialized views by refreshing them after changes are
made to their master tables. The refresh method can be incremental (fast refresh) or
complete. For materialized views that use the fast refresh method, a materialized view
log or direct loader log keeps a record of changes to the master tables.

Materialized views can be refreshed either on demand or at regular time intervals.
Alternatively, materialized views in the same database as their master tables can be
refreshed whenever a transaction commits its changes to the master tables.

重新整理物化檢視
1. 物化檢視重新整理方式 : 增量(快速)重新整理或者完全重新整理
2. 快速重新整理方式 : 使用物化檢視日誌或直接載入日誌來記錄主表資料的修改
3. 物化檢視可以依據請求重新整理,也可以按照定期的時間間隔重新整理
4. 當物化檢視與其對應的主表在同一個資料庫時 , 那麼物化檢視可以在其主表的事務提交後同步重新整理

[@more@]