--Create Local Table
CREATE TABLE xxzz_test_local
(
ID     NUMBER,
user_name     VARCHAR2(20),
creation_date DATE,
CONSTRAINT xxzz_test_local_pk PRIMARY KEY(ID)
)
TABLESPACE  applsysd;
--Create MV Log on Local View
CREATE MATERIALIZED VIEW LOG ON apps.xxzz_test_local
TABLESPACE  applsysd
WITH PRIMARY KEY;
--Create MV
CREATE MATERIALIZED VIEW apps.xxzz_test_mv
TABLESPACE  applsysd
REFRESH FAST
START WITH SYSDATE NEXT SYSDATE + 1
WITH PRIMARY KEY
AS
SELECT * FROM apps.xxzz_test_local;

--View Data
SELECT *
  FROM apps.xxzz_test_local;
SELECT *
  FROM apps.xxzz_test_mv;
--Refresh manually
EXECUTE dbms_mview.refresh('apps.xxzz_test_mv','f');

说明：对于复杂查询，只能用Complete方式刷新，手动Execute MV时，Complete的参数是'c'。

除非该复杂查询里面的主档表有索引，才能建MV LOG，进而Fast方式更新