Re: Mview not telling log refresh is done
- From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
- To: vincent.verpoort@xxxxxxxxx, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 17:09:27 +0200
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.name, 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.
--
Regards,
Yavor Ivanov
Senior Database Expert
Stemo Ltd
On Tue, 16 Jan 2007 16:52:05 +0200, Vincent verpoort
<vincent.verpoort@xxxxxxxxx> 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 ?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
