Materialized views not refreshing

From: Jared Still <jkstill_at_cybcon.com>
Date: Tue, 25 Feb 2003 00:48:41 -0800
Message-ID: <F001.0055806A.20030225004841@fatcity.com>

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: 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). Received on Tue Feb 25 2003 - 02:48:41 CST