| 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
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: 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 - 07:59:00 CST
 |
 |