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;