August 4th, 2011, 02:33 PM
Refresh Materialized views based on remote views
I have a created a materialized view which is based on a view on remote database. Now how do I refresh the view.
Materialized view is created by
CREATE MATERIALIZED VIEW mv_employee_name
AS SELECT EMPLID, EMPL_NAME
WHERE REGION = 'US';
I am wondering how the refersh happens or how do I specify the refresh clause.
REFRESH FAST option is looking for VIEW LOG on the master table but in this case its a remote view, so I cannot create any object on remote db.
August 10th, 2011, 09:24 AM
make it REFRESH ON DEMAND
You need use a job to refresh the Materialized view.