I have 3 databases on different servers, one database is master and the others are sites.
I need to replicate one master's table to the other databases using materialized views. This table hasn't a primary key, it has a unique index, so I can change it to primary key. I created a materialized view log on this table.
In the other sites (databases), I created a materialized views with fast refresh using row id. I read the documentation but I got confused about it was possible to create these materialized views without disturbing each other in the fast refresh process.
And why am I asking you this? Because I got the following error when I made the second refresh:
ORA-12034: materialized view log on "OWNER"."TABLE" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
I made the materialized view fast refresh in one site (database) and everything went okay. But, I found this happened when the second materialized view made the fast refresh.
So, this only works with materialized views using primary key?