ORacle 创建物化视图

create materialized view log on IMS.dgp_exportdata with rowid;

CREATE MATERIALIZED VIEW V_DGP_EXPORTDATA
REFRESH FAST ON DEMAND with rowid
START WITH SYSDATE NEXT SYSDATE + 300/86400
AS
SELECT MAINDATA_UUID,
          MAINDATA_CODE,
          MAINDATA_NAME,
          MAINDATA_CONTENT,
          MAINDATA_FIELD_UUID,
          MAINDATA_FIELD_CODE,
          MAINDATA_FIELD_NAME,
          MAINDATA_VALUE,
          TO_CHAR (MIANDATA_TIME, 'yyyy/mm/dd hh24:mi:ss') date_time,
          TO_CHAR (MIANDATA_TIME, 'yyyymmdd') date_char
     FROM dgp_exportdata;