How to refresh materialized view in oracle

materialized-views, oracle

Solution

try this:

DBMS_SNAPSHOT.REFRESH( 'v_materialized_foo_tbl','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.

Problem

Iam trying to refresh the materialized view by using: ``` DBMS_MVIEW.REFRESH('v_materialized_foo_tbl') ``` 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; ``` it's throwing an error again. Kindly suggest a solution for this issue. Thanks, Srinivas

Original source