Materialized views not refreshing
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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Materialized views not refreshing
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: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
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, 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
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 offending MV's and associated logs: they seem to be working now. All very strange. I'm going to trace both ends if it acts up again. Thanks, Jared On Tuesday 25 February 2003 02:29, Connor McDonald wrote: 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, 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Materialized views not refreshing
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 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: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Darrell Landrum INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
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 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Henry Poras INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
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 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
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 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: 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 and recreate the snapshot logs. Brian - Original Message - Date: Tuesday, February 25, 2003 1:39 pm 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 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] 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 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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zale Dba INET: [EMAIL PROTECTED] 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
Re: Materialized views not refreshing
Jared, I joined this thread late; so I apologize if this suggestions has been tried already. Sometimes the purge of teh MLOG$ tables leave the table in such fragmented state that the refresh takes a considerably long time and thus it appears that the MV are not refreshing. Could you try the following Quiesce the master table(s) Truncate the MLOG$ tables (not delete) Unquiesce the master tables(s) Refresh Full Refresh Fast Manually once then leave it to the jobns to do the refresh. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 2:39 PM 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 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Arup Nanda INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Materialized views not refreshing
Yes, I tried that as well on one of the MV's. Didn't help. Thanks, Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/25/2003 12:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 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 and recreate the snapshot logs. Brian - Original Message - Date: Tuesday, February 25, 2003 1:39 pm 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 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Materialized views not refreshing
Thanks for pointing it out, but I did remember to set it back. Jared Zale Dba [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/25/2003 12:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 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 [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ STOP MORE SPAM with the new
Re: Materialized views not refreshing
Arup, Sounds like good advice. I had some downtime at 1:00 AM, and rebuilt all the logs and MV's, and now it's all working fine. I'm going to try and duplicate the problem in a test env. If I can get it to fail in test, I will try this procedure. Jared Arup Nanda [EMAIL PROTECTED] Sent 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 tried already. Sometimes the purge of teh MLOG$ tables leave the table in such fragmented state that the refresh takes a considerably long time and thus it appears that the MV are not refreshing. Could you try the following Quiesce the master table(s) Truncate the MLOG$ tables (not delete) Unquiesce the master tables(s) Refresh Full Refresh Fast Manually once then leave it to the jobns to do the refresh. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 2:39 PM 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 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Arup Nanda INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB