Posted By: Anonymous
Iam trying to refresh the materialized view by using:
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
it’s throwing an error again.
Kindly suggest a solution for this issue.
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.