1、在SOURCE DB 上建立日志

CREATE MATERIALIZED VIEW LOG ON MESPRD.LOTTABLESPACE TS_IMESTRX_01PCTUSED    0PCTFREE    60INITRANS   2MAXTRANS   255STORAGE    (            INITIAL          5M            NEXT             5M            MINEXTENTS       1            MAXEXTENTS       UNLIMITED            PCTINCREASE      0            BUFFER_POOL      DEFAULT           )NOCACHELOGGINGNOPARALLELWITH PRIMARY KEYEXCLUDING NEW VALUES;

2、在目标DB上建立物化视图（基于PK）

 CREATE MATERIALIZED VIEW  RPTPRD.FPALOTTABLESPACE TS_DRPTTRX_01NOCACHELOGGINGNOCOMPRESSNOPARALLELUSING INDEX            TABLESPACE TS_IRPTMST_01REFRESH FASTSTART WITH SYSDATENEXT SYSDATE + 10/1440 WITH PRIMARY KEYAS SELECT * FROM WHERE lotstate = 'Released' ;  3、在目标DB上建立物化视图（基于普通索引） CREATE MATERIALIZED VIEW AB01 TABLESPACE BASE_DATANOCACHELOGGINGNOCOMPRESSNOPARALLELREFRESH FORCESTART WITH SYSDATENEXT SYSDATE + 12/24  WITH ROWIDAS SELECT * FROM ;CREATE UNIQUE INDEX AB01_AAB001_IDX ON AB01(AAB001)LOGGINGTABLESPACE BASE_IDXNOPARALLEL;