Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: Mview not telling log refresh is done

From: Yavor Ivanov <>
Date: Tue, 16 Jan 2007 17:09:27 +0200
Message-ID: <>

	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:
select, r.snapshot_site, l.current_snapshots

   from dba_registered_snapshots r, dba_snapshot_logs l   where r.snapshot_id = l.snapshot_id
  order by 3

        Take a lok at the "older ones" - maybe they are the phantoms which do not allow the log to be cleared.

Yavor Ivanov
Senior Database Expert
Stemo Ltd

On Tue, 16 Jan 2007 16:52:05 +0200, Vincent verpoort <> wrote:

> HI
> I have a little problem with the mviews and there logs i have a 10.2 g db
> that holds the mviews and a 9.2 i that holds the log files
> Problem is that the log files are getting very big while fast refresh is
> going good, and complete refresh also doesend clean them up. So what you
> might say now is just do a move to free up the space that is left with the
> exteniding, but the logs really contain data. So the log are really full
> with info for the mviews. Now i can not do a complete refresh and drop the
> log files as there is just to much data. I tryed a dbms purge_log and this
> works. Im still abel to do a fast refresh or compleet.
> It looks like when de 10g machine is done with it refresh of the mview it
> does not give a message back to the 9i that its sucsessful in its refresh (
> fast ior compleet )
> Anyone ever see this before ? and so know a solution ?
Received on Tue Jan 16 2007 - 09:09:27 CST

Original text of this message