Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Application Development
Oracle Database Express Edition (XE)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 6, 2012 12:54 AM by
ORACLE 11G XE-Materialized view info/issue
Aug 30, 2012 2:11 AM
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;
This content has been marked as final.
Show 1 reply
Re: ORACLE 11G XE-Materialized view info/issue
Oct 6, 2012 12:54 AM
in response to
The name of this forum is "Streams" not "Materialized Views." Please post your question in the correct forum. Thank you.