Stopping materialized view Refresh
482078Dec 10 2007 — edited Dec 10 2007Hi,
I have created a materialized view and had executed a procedure to refresh the view.
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,'dbms_mview.refresh(''test_mv'',''C'');',SYSDATE, 'SYSDATE + 1/4');
COMMIT;
END;
/
Now i want to drop this materialized view and stop the scheduling of this refresh on materalized.
Can you please tell me how to stop the refresh of this view completely.