如何在Oracle中刷新实例化视图 [英] How to refresh materialized view in oracle

问题描述

我正在尝试使用以下方法刷新物化视图:

Iam trying to refresh the materialized view by using:

DBMS_MVIEW.REFRESH('v_materialized_foo_tbl')

但是它抛出了无效的sql语句.

But it's throwing invalid sql statement.

然后我创建了一个像这样的存储过程:

Then I have created a stored procedure like this:

CREATE OR REPLACE 
PROCEDURE MAT_VIEW_FOO_TBL 
IS
BEGIN
   DBMS_MVIEW.REFRESH('v_materialized_foo_tbl')
END MAT_VIEW_FOO_TBL IS;

此过程已成功创建，但是当我使用

This procedure has been created successfully but when i am calling this procedure with

MAT_VIEW_FOO_TBL;

它再次引发错误.

请为此问题提供解决方案.

Kindly suggest a solution for this issue.

谢谢， 斯里尼瓦斯

推荐答案

尝试一下:

DBMS_SNAPSHOT.REFRESH( 'v_materialized_foo_tbl','f'); 

第一个参数是mat_view的名称，第二个定义refresh的类型. f 表示快速刷新. 但请记住，它将覆盖任何其他刷新计时选项.

first parameter is name of mat_view and second defines type of refresh. f denotes fast refresh. but keep this thing in mind it will override any any other refresh timing options.

这篇关于如何在Oracle中刷新实例化视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！