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
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
Probably a little obvious, but what do you get when
you slap a trace on the refresh job (on both source
and target db's) - do you see any attempt to read rows
from the mview log at all? any updates being attempted
on the target?
hth
connor
--- Jared Still [EMAIL PROTECTED] wrote:
Dear list,
You're right, it is obvious, but I hadn't yet done it.
The thought had occurred to me to do this at both nodes,
but I think lack of sleep has dulled my senses a bit and I
forgot to do it. All the work involved in repeating myself
in the TAR maybe, I dunno.
I've dropped and recreated the
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
Is the job even firing at all? It is a common step in upgrading to set
job_queue_processes=0 and this will prevent materialized views from refreshing
automatically. Make sure this is greater than 0; I normally set it to 2.
[EMAIL PROTECTED] 02/25/03 04:29AM
Dear list,
Have any of you every
cc:
Sent by: rootSubject: Re: Materialized views not
refreshing
Jared,
Does it work if you do a manual refresh?
Henry
-Original Message-
Sent: Tuesday, February 25, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Dear list,
Have any of you every experienced MV's not refreshing
for no particular reason?
We have been using some simple MV's
Didn't help to do it manually.
On Tuesday 25 February 2003 06:14, Henry Poras wrote:
Jared,
Does it work if you do a manual refresh?
Henry
-Original Message-
Sent: Tuesday, February 25, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Dear list,
Have any of you every
Yes, the jobs were firing, verified by timestamps in both
the dba_jobs and dba_refresh views.
On Tuesday 25 February 2003 05:33, Darrell Landrum wrote:
Is the job even firing at all? It is a common step in upgrading to set
job_queue_processes=0 and this will prevent materialized views from
jkstill To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED] @cybcon.com cc:
Sent by: rootSubject: Re: Materialized
views not refreshing
02/25/2003 06:49
AM
in upgrading
to set
job_queue_processes=0 and this will prevent materialized views from
refreshing automatically. Make sure this is greater than 0; I
normally set
it to 2.
[EMAIL PROTECTED] 02/25/03 04:29AM
Dear list,
Have any of you every experienced MV's not
refreshing
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
and this will prevent materialized views from
refreshing automatically. Make sure this is greater than 0; I normally
set
it to 2.
[EMAIL PROTECTED] 02/25/03 04:29AM
Dear list,
Have any of you every experienced MV's not
refreshing
for no particular reason?
We have been using some
of list
ORACLE-L [EMAIL PROTECTED]
@cybcon.com cc:
Sent by: rootSubject: Re: Materialized views not
refreshing
: Materialized views not refreshing
Jared -
I assume you're attempting fast refreshes - Is it feasible to attempt a
full refresh?
I remember problems w/ snapshots (in the 8.0.4 days) where the snapshot
logs would just stop working. I had to perform a full refresh of the
snapshots, then drop
: 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
by: [EMAIL PROTECTED]
02/25/2003 12:54 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Materialized views not refreshing
Jared,
I joined this thread late; so I apologize if this suggestions has been
18 matches
Mail list logo