Re: Mview not telling log refresh is done

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

--
http://www.freelists.org/webpage/oracle-l