Check bug 2259259. The fix is to create a dummy MV (where 0=1) that will force the snapshot to look at the log again. On the second time around it purges the M$LOG (or at least it has for us)
Master - 8.1.7.4 DecAlpha Slave - 8.1.6.3 Win2K Jared Still <jkstill To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> @cybcon.com> cc: Sent by: root Subject: Re: Materialized views not refreshing 02/25/2003 02:39 PM Please respond to ORACLE-L No, they were not being purged. On Tuesday 25 February 2003 05:59, Thomas Day wrote: > We had the problem where the M$LOG was not being purged after the > materialized view was updated. That doesn't seem to be your problem > though. > > > > > Jared Still > <jkstill To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> @cybcon.com> cc: > Sent by: root Subject: Re: Materialized > views not refreshing > > > 02/25/2003 06:49 > AM > Please respond > to ORACLE-L > > > > > > > > No errors, no trace files. Refreshing via refresh group or > directly via the snapshot both failed to update the MV. > > They've since been recreated and are working at the moment. > > I'll slap a big ole note on my forehead that says 'run a trace on > them stupid!' so I will remember to do so if these start failing again. > > Off to bed for me. > > Jared > > On Tuesday 25 February 2003 02:29, Stephane Faroult wrote: > > >Dear list, > > > > > >Have any of you every experienced MV's not > > >refreshing > > >for no particular reason? > > > > > >We have been using some simple MV's for several > > >months > > >with no problem. Now after upgrading our app and > > >database, > > >there seem to be problems. > > > > > >Servers: > > > > > >Master: Win2k SP2 Oracle 8.1.7.4.1 > > > > > >Slave: NT 4 SP6 Oracle 8.1.7.4.1 > > > > > >These databases were previously 8.1.6. The master > > >database > > >now has a UTF8 character set, and all tables have > > >NVARCHAR2 > > >columns. > > > > > >These are being converted in the MV using: > > > translate("COLUMN_NAME" using char_cs) > > >COLUMN_NAME > > >when creating the MV. > > > > > >There are no errors, no trace files. Data is > > >updated on the master > > >node and never appears in the slave. > > > > > >The data continues to persist in the MLOG$ tables. > > >I've verified there > > >is only a single MV against each MV LOG, so the > > >data in MLOG$ should > > >be truncated after a refresh, but the fact that it > > >isn't makes it fairly > > >obvious that the refresh is not working properly. > > > > > >I have a serverity 1 TAR open now with Oracle, but > > >so far all that's > > >been accomplished with the TAR is me repeating > > >everything I > > >included initially. > > > > > >Any advice appreciated, as it's rather important to > > >get this working again. > > > > > >Jared > > > > Jared, > > > > What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can > > you wrap the dbms_refresh call into something to catch the error ? (if > > you > > > feel lazy I think that there is code to this effect on the Oriole site in > > one of the 'Aunt Augusta' papers). > > > > Regards, > > > > Stephane Faroult > > Oriole > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).