dear all
I have two databases ; "local" and "remote"
on the remote i created a materialized view log for each table
example:
--------------------------------------
CREATE MATERIALIZED VIEW LOG ON BULLETIN_TYPE WITH SEQUENCE,ROWID;
----------------------------------
on the local database i created the materialized views
example:
CREATE MATERIALIZED VIEW LV_BULLETIN_TYPE_MV
REFRESH FAST
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
AS
SELECT TYPE_CODE ID,
TYPE_DESC DESC_A
FROM BULLETIN_TYPE@EGID_SEFIT;
------------------------------------------
no errors occurs at all
now i inserted a row on the master table located on the remote database
-------------------------------
insert into BULLETIN_TYPE(id,name)
values(1,'test');
commit;
now whe i query the materialized view AND NOW ROWS FOUND
SQL> SELECT * FROM LV_BULLETIN_TYPE_MV ;

no rows selected
I ASK NOW, SHOULD I refresh the materialied view manualy using the "dbms_mview.refresh"
I do not want to refresh the materialized view in this way
i want it to be refreshed automatically with the every change on the remote database


please help

السلام عليكم ورحمة الله وبركاته

راجع الكود الخاص ب create materialized view من ال documentation

والإجابة انه يجب عليك عن بناء ال materialized view
CREATE MATERIALIZED VIEW LV_BULLETIN_TYPE_MV
REFRESH FAST
{on commit}
لكى يحدث ال refresh عند كل commit