#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    1
    Rep Power
    0

    Refresh Materialized views based on remote views


    Hi,

    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
    FROM VEMPDATA@REMOTEDB
    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.

    Please help

    Thanks
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    make it REFRESH ON DEMAND

    You need use a job to refresh the Materialized view.

IMN logo majestic logo threadwatch logo seochat tools logo