Frank <fvanbortel_at_netscape.net> wrote in message news:<3E9F0E9F.7070007_at_netscape.net>...
> 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!
Yes, 9.2.0.1.0 on WindowsXP.
Received on Fri Apr 18 2003 - 00:42:09 CDT
