1 Reply Latest reply: Oct 6, 2012 12:54 AM by damorgan RSS

    ORACLE 11G XE-Materialized view info/issue

    kiran patil
      Hi,

      I have two Oracle XE databases with the version 11g, now i want to sync both of this dbs using materialized view feature.

      I have created base table in primary db and created materialized view in secondary db using db link.

      It got created and am able to view the records first time. but when i am selecting view next time its not reflecting changed records.

      Please suggest what needs to do to get it reflected in secondary db.

      mv query is as below

      CREATE MATERIALIZED VIEW mv_emp_pk
           REFRESH FAST START WITH SYSDATE
           NEXT SYSDATE + 1/86400
           WITH PRIMARY KEY
           AS SELECT * FROM emp@remote_db;

      Regards
      Kiran