"Timothy Madsen" <timothy_madsen_at_bigfoot.com> wrote in message news:<b7hjm3$j4v$1_at_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.
Are you sure? Without a materialized view log, you should not be able
to create the MV with "REFRESH FAST" - ON COMMIT or otherwise. MV log
is needed if you wish to fast refresh your MVs.
Received on Tue Apr 15 2003 - 19:02:39 CDT
