Jusung Yang wrote:
> 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.
>
> - Jusung Yang
Thanks!
At least it verifies the problem is resolved... Must get really 9.2
re-installed here... 9iAS ruined my 9i database (Linux)
--
Regards, Frank van Bortel
Received on Fri Apr 18 2003 - 05:47:18 CDT