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. 当物化视图与其对应的主表在同一个数据库时 , 那么物化视图可以在其主表的事务提交后同步刷新
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-981945/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2003008
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
