Re: complete refresh of large materialized view, online or any alternatives?

From: Martin Dachselt <dachselt_at_firstgate.de>
Date: 30 Jul 2003 11:01:40 -0700
Message-ID: <bdafd998.0307301001.66d1332d@posting.google.com>

JusungYang_at_yahoo.com (Jusung Yang) wrote in message
> Nope. You can not even use online redefinition on the MV base table.

Of course you can. You have to bind two or more snapshots (for example one dummy snapshot and your desired snapshot) in one refresh group. Then oracle uses delete instead of trunc.

Example from oracle:
create snapshot snap_test
refresh complete
as select * from test_at_db_link;

create snapshot snap_dual
 refresh complete
 as select * from dual;

execute dbms_refresh.make(       
name      => 'group1',       
list      => 'snap_test,snap_dual',     
next_date => sysdate,       
interval  =>'sysdate+1/24',       

implicit_destroy =>true);

Martin Received on Wed Jul 30 2003 - 13:01:40 CDT