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/