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/