Mview not telling log refresh is done
- From: "Vincent verpoort" <vincent.verpoort@xxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 15:52:05 +0100
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 ?
--
Vincent Verpoort
,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_
Communiceren is begrepen worden
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
Other related posts:
