CREATE MATERIALIZED VIEW FMV_TABLE_ONE
ON PREBUILT TABLE WITH REDUCED PRECISION
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
FOR UPDATE
AS
SELECT * FROM TABLE_ONE@HIS_TO_NEW';用job每隔5分钟刷新一次,但是会有数据没有被同步到表中.
ON PREBUILT TABLE WITH REDUCED PRECISION
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
FOR UPDATE
AS
SELECT * FROM TABLE_ONE@HIS_TO_NEW';用job每隔5分钟刷新一次,但是会有数据没有被同步到表中.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货