| 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
Thanks for pointing it out, but I did remember to set it back.
Jared
"Zale Dba" <zaledba_at_hotmail.com>
Sent by: root_at_fatcity.com
02/25/2003 12:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: Materialized views not refreshing
Jared,
I know this may sound stupid, but when you upgrade you change job_queue_processes to zero. Did you reset your init parameter back after
the upgrade? I have seen that cause this problem before.
Hope it is this simple.
Later
Charles Hart
>From: Jared Still <jkstill_at_cybcon.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Materialized views not refreshing
>Date: Tue, 25 Feb 2003 11:39:09 -0800
>
>
>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: Zale Dba INET: zaledba_at_hotmail.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: INET: Jared.Still_at_radisys.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 - 18:13:41 CST
 |
 |