Purge materialized view log automatically.

From: Chuan Zhang <Chuan.Zhang_at_transact.com.au>
Date: Mon, 05 May 2003 17:01:56 -0800
Message-ID: <F001.00590739.20030505170156@fatcity.com>

Hi, DBAs,

   According to Oracle, "when the materialized view is refreshed, the corresponding row(s) are removed from the log." But I could not make it happened. No matter what I use "alter materialized view ... refresh complete, fast, force", the underline materialized view log won't delete its rows. By the way, I have tried refresh all the related materialized views, the underline materialized view log is the same. Do you know why or what the requirements for Oracle automatically remove the rows in materialized view log.

This is Oracle 9.2.0 on Linux Red Hat 8.

Much appreciated for your input.

Chuan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Chuan Zhang
  INET: Chuan.Zhang_at_transact.com.au

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 Mon May 05 2003 - 20:01:56 CDT