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.