0 Replies Latest reply: Apr 12, 2013 4:30 PM by WilliamMuñoz RSS

    One master table and two materialized views on different databases

    WilliamMuñoz
      Hi,

      Operating System: AIX 7.1
      Oracle Database: 11g Release 2 - Patch set 11.2.0.3.0

      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?

      Best regards,