http://www.itpub.net/thread-1308625-1-1.html

primary key

1、user test下

create table B
(
a VARCHAR2(2) not null,
b NUMBER
)；

alter table B
add constraint PK_B primary key (A)；

grant select on B to TEST2;

create materialized view log on b with primary key；

grant select on mlog$_b to test2；

2、user test2下

create table BB
(
a VARCHAR2(2) not null,
b NUMBER,
c DATE default sysdate
)；

alter table BB
add constraint B_PK primary key (A)；

create materialized view bb
on prebuilt table
refresh fast with primary key
start with sysdate next sysdate+1/14400 as
--on commit as
select b.a,b.b from test.b；

3、user test1下

insert into b values('03','3');

update b set b.b=22 where b.a='02'

4、user test2下

exec dbms_mview.refresh('BB','C');

rowid
create materialized view log on b with rowid;

grant select on mlog$_b to test2

rowid 方式不可以预建表

ITPub博客

物化视图

最新文章