Create MV
CREATE MATERIALIZED VIEW "ZQ"."MV01" TABLESPACE "OLTP" NOLOGGING CACHE USING INDEX TABLESPACE "OLTP" REFRESH FORCE ON DEMAND ENABLE QUERY REWRITE AS select count(*) from tbl2
BEGIN DBMS_STATS.GATHER_TABLE_STATS(ownname =>'ZQ', tabname => 'MV01'); END;
CREATE MATERIALIZED VIEW LOG ON ZQ.EMP NOCACHE WITH PRIMARY KEY ("AGE", "ENAME") EXCLUDING NEW VALUES
page revision: 1, last edited: 06 May 2009 10:50