| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Materialized views not refreshing
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 <ORACLE-L_at_fatcity.com>
@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 <ORACLE-L_at_fatcity.com> @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: jkstill_at_cybcon.com
>
> 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com 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: ListGuru_at_fatcity.com (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: tday6_at_csc.com 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: ListGuru_at_fatcity.com (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).Received on Tue Feb 25 2003 - 15:14:03 CST
 |
 |