I have a materialized view that refreshes every day at 9 AM, and working (configuration was added in Toad).

Now, I’m attempting to refresh the materialized view on demand. For this purpose, the following code is used:

BEGIN 
DBMS_MVIEW.REFRESH('your_materialized_view_name'); 
END;

Let’s say I run this code at 2 in the afternoon. But here’s the problem: after I run it, the view starts updating itself at 2 PM every day instead of 9 AM like before.

Is there a way to make sure it keeps updating at 9 AM, no matter when I manually update it?

Can we add something to the code to make that happen?

BEGIN 
DBMS_MVIEW.REFRESH('your_materialized_view_name'); 
-- Additional code to enforce the 9 AM schedule
END;