Re: Materialized views not refreshing

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).