Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized View Log - ??
Jusung Yang wrote:
> In case Richard still did not convince you... I think you might be
> confusing "FAST" with "ON COMMIT". "FAST" refers to the "incremental"
> refreshing mechanism, while "ON COMMIT" has to do with the "timing" of
> the refresh. Just because your trigger on the MV fires whenever you
> commit on the master table, does not mean the refresh is "FAST" or
> "incremental". Most likely you don't have MV log, but I don't believe
> your MV is created with the "REFRESH FAST" option. Here is a little
> demo:
>
> SQL> create table test5 as select * from test1;
<snip!>
Which version? tried to demo this on 8.1.7.2/Win2k and ran into some
bug, stating you cannot do a fast refresh with in commit.
It's supposed to be solved in 9i (sounds familiar?) but wonder if you can confirm that by stating your version/platform.
Thanks!
-- Regards, Frank van BortelReceived on Thu Apr 17 2003 - 15:29:19 CDT
![]() |
![]() |