Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Materialized View Log - ??

Materialized View Log - ??

From: Timothy Madsen <timothy_madsen_at_bigfoot.com>
Date: Tue, 15 Apr 2003 14:40:00 -0400
Message-ID: <b7hjm3$j4v$1@bob.news.rcn.net> 





Hello,


I am not clear on why/when one needs to use a 'materialized view log'.



Currently, in my Oracle 8.1.7.3.0 database, I have created a few
materialized views (refresh fast on commit) - simply for the purpose of
having a 'commit trigger'.



It seems to work fine without having the materialized view log being
created - so I was wondering under what circumstances the log is required
and what it does?



Thanks.


Tim.
Received on Tue Apr 15 2003 - 13:40:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US