Path: news.netfront.net!news.glorb.com!postnews.google.com!e25g2000prg.googlegroups.com!not-for-mail
From: "ajaysm85@gmail.com" <ajaysm85@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Problem with Materialized View Log
Date: Sun, 30 Dec 2007 21:26:12 -0800 (PST)
Organization: http://groups.google.com
Lines: 15
Message-ID: <38f7749c-1b3b-49c3-8b33-5a52e7f5ffde@e25g2000prg.googlegroups.com>
NNTP-Posting-Host: 58.68.94.83
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1199078772 16442 127.0.0.1 (31 Dec 2007 05:26:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 31 Dec 2007 05:26:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e25g2000prg.googlegroups.com; posting-host=58.68.94.83; 
 posting-account=rwLkUAoAAADr5VgK3rkDm9xuhekOPEHP
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) 
 Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 proxy.maxhypermarkets.com:8080 (squid/2.6.STABLE13)
Xref: news.netfront.net comp.databases.oracle.server:180695


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.