materialized viewTag ArchiveSubscribe

    ORASOA side:   create table tab1(c1 char(10),c2 char(10),c3 char(10));   begin for i in 1..10000 loop insert into tab1 values(i,’A’,’B’); end loop; end;   alter table tab1 add constraint pk_tab1 primary key(c1);   create materialized view log on tab1;—– Default is Primary Key   SQL> select * from… Continue Reading Materialized View Example