专著oracle 技术
记录维护生产数据库的点点滴滴....
物化视图组进行刷新
上一篇 /
下一篇 2008-03-19 21:22:54
/ 个人分类：Oracle DBA
当我们需要同步数据时，很多时候用到物化视图，在默认建立物化视图时，就会默认建立了物化视图组，而每个物化视图就建立一个job 进行数据同步。这个时候就需要手动建立物化视图组，启动一个job来完成。
利用 DBMS_REFRESH 程序包，详细见oracle document
"ADD Procedure" Adds materialized views to a refresh group.
"CHANGE Procedure" Changes the refresh interval for a refresh group.
"DESTROY Procedure" Removes all of the materialized views from a refresh group and deletes the refresh group.
"MAKE Procedure" Specifies the members of a refresh group and the time interval used to determine when the members of this group should be refreshed.
"REFRESH Procedure" Manually refreshes a refresh group.
"SUBTRACT Procedure" Removes materialized views from a refresh group.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
