oracle物化视图简单测试

测试用数据库oracle 11g

 

create table test as select rownum id, object_id,object_name from all_objects;

 

alter table test add constraint pk_test primary key (id);

 

--要使用快速刷新必须在master table上建立log

create materialized view log on test with primary key;

 

create materialized view test_mv refresh fast on commit as select * from test;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/2281175/viewspace-745990/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/2281175/viewspace-745990/