Stop MVIEW auto refresh
Stop Refresh:
Connect as mview owner.
select * from user_jobs where broken ='N';
You will see mview refresh job in WHAT column:
dbms_refresh.refresh('"[OWNER]"."[MVIEW_NAME]"');
Execute the following command using the JOB_ID that you can see from the output of above statement:
begin
dbms_job.run(JOB_ID);
commit;
end;
/
Example:
begin
dbms_job.broken(116,TRUE);
commit;
end;
/
Start Refresh again:
begin
dbms_job.run(JOB_ID);
commit;
end;
/
Example:
begin
dbms_job.broken(116,TRUE);
commit;
end;
/
MVIEW will start refreshing again.