Problem with Materialized View Log
Date: Sun, 30 Dec 2007 21:26:12 -0800 (PST)
We are using replication concept in our project. It contains
different schemas which is location wise created. Data flows
vertically in both directions. E.g. If we take schemas like HO (Head
Office),RO (Regional Office),ST(Store)
then data flows from HO-->RO-->ST and back from ST-->RO-->HO. Like this we have 4 schemas(locations) under RO. So all data from all schemas has to pass through RO. Here the problem is occurring. None of the Materialized View logs in RO are flushed after replication. Even one month old data persists in the mlog. I am not able to find the reason. Can this be a reason for longer time in replication?
Please help me with this problem. Received on Sun Dec 30 2007 - 23:26:12 CST