As we are well known that whole technology is getting change towards advancement. All things are working on automatic. Even software works on autonomous. In RDBMS we have a feature to stop automatic refresh MView.
Let’s have look how do we stop automatic refresh MView
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]"');
We execute the following command using the JOB_ID that you can see from the output of the above statement:
begin dbms_job.run(JOB_ID); commit; end; /
Example:
begin dbms_job.broken(116,TRUE); commit; end; /
Code for Start Refresh again:
begin dbms_job.run(JOB_ID); commit; end; /
Example:
begin dbms_job.broken(116,FALSE); commit; end; /
MVIEW will start refreshing again.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
