Oracle-L: RE: Materialized views not refreshing

From: Henry Poras <hporas_at_etal.uri.edu>
Date: Tue, 25 Feb 2003 06:14:28 -0800
Message-ID: <F001.005586C8.20030225061428@fatcity.com>

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: 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: Henry Poras
INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------