Hi
I have a materialised view which needs to refreshed every half an hour.
Is it possible to refresh the view without using triggers.
Do we have something similar to DBMS_SCHEDULER.CREATE_JOB in postgresql to create a job that can be scheduled to refresh the views periodically.
Thanks in advance..