I have created materialized views and used to refresh for every 10 hrs but my requirement is Mviews should refresh at 8 PM on every sunday.
Please guide me to solve the problem.
Thanks in Advance.
You can also referto the following metalink document for more details about th refresh job.
How creating an mview with the NEXT option automatically creates a refresh job (Doc ID 742355.1)