Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Mview not telling log refresh is done

Re: Mview not telling log refresh is done

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 17 Jan 2007 21:39:15 +0800
Message-Id: <7.0.1.0.0.20070117213709.01b48ea8@singnet.com.sg>

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
Received on Wed Jan 17 2007 - 07:39:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US