Problem with Materialized View Log

Hi,

    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