oracle mv篇

CREATE MATERIALIZED VIEW LOG

---

CREATE MATERIALIZED VIEW LOG ON t_mvp
WITH PRIMARY KEY,ROWID,COMMIT SCN ,SEQUENCE  (brd,nm) 
INCLUDING NEW VALUES
PURGE IMMEDIATE syNCHRONOUS;

SELECT * FROM user_mview_logs

---

 

 

CREATE MATERIALIZED VIEW

实时刷新功能

---

DROP MATERIALIZED VIEW mv_t ;

CREATE MATERIALIZED VIEW mv_t
BUILD IMMEDIATE
REFRESH 
   FAST 
   WITH PRIMARY KEY 
   ON COMMIT
--FOR UPDATE
ENABLE QUERY REWRITE
AS
SELECT * FROM t_mvp;