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
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License