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

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

Mview not telling log refresh is done

From: Vincent verpoort <vincent.verpoort_at_gmail.com>
Date: Tue, 16 Jan 2007 15:52:05 +0100
Message-ID: <9b68098b0701160652n6f276755p5ff476c1ed08662b@mail.gmail.com>


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

^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 16 2007 - 08:52:05 CST

Original text of this message

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