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 -> Re: Materialized View Log - ??

Re: Materialized View Log - ??

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 17 Apr 2003 22:29:19 +0200
Message-ID: <3E9F0E9F.7070007@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!

-- 
Regards, Frank van Bortel
Received on Thu Apr 17 2003 - 15:29:19 CDT

Original text of this message

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