MV Log used by three databases
My scenario is as follows:
I have the table "X" in database "A" and created a MV log with the command:
CREATE MATERIALIZED VIEW LOG ON X WITH PRIMARY KEY, ROWID;
Now, I created in the database "B" a MV with the command:
CREATE MATERIALIZED VIEW "MVX_B"
REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/720
WITH PRIMARY KEY
AS SELECT * FROM X@A;
And created in the database "C" a MV with the command:
CREATE MATERIALIZED VIEW "MVX_C"
REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/720
WITH PRIMARY KEY
AS SELECT * FROM X@A;
Finally I created in the database "D" a VM with the command:
0