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;