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
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.