Re: Mview not telling log refresh is done
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: "Vincent verpoort" <vincent.verpoort@xxxxxxxxx>
- Date: Wed, 17 Jan 2007 21:39:15 +0800
And also if you have an MV that had registered to do Fast
Refresh's but is no longer refreshing itself
(eg the DBMS_MVIEW.REFRESH job for the MV has been dropped because
users "no longer need the MV")
At 11:09 PM Tuesday, Yavor Ivanov wrote:
I think you problem is deeper.
The described behaviour sounds like you have more mvews
registered in the log, than you have realy refreshing. This may
happen if you drop a database and it does not unregister it's
mviews form the master; or if you drop some mview and the
connection with the master is not working in that exact moment, so
the mview does not unregister itself. You can check what registered
mviews you have anf when they are refreshed using the folowing
query on the master site:
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
