摘要: 对于oracle10g简单方法:1. 先建立一个物化视图,不用指明刷新参数,只要create materialized view,如CREATE MATERIALIZED VIEW mv_emp AS SELECT * FROM scott.emp;2. 建立一个用来刷新物化视图的存储过程,如CREATE OR REPLACE PROCEDURE auto_refresh_mview_job_p... 阅读全文
posted @ 2010-11-24 10:43 马侃 阅读(1088) 评论(0) 推荐(0)