CREATE MATERIALIZED VIEW TESTRESULT 
ON PREBUILT TABLE WITH REDUCED PRECISION
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
AS 
SELECT...
FROM...
WHERE...

此物化视图没有支持MATERIALIZED VIEW LOG.如上面的子句所示,这个MV有“ON DEMAND”指定,并根据Oracle文档,

“[ON DEMAND] indicate[s] that the materialized
view will be refreshed on demand by
calling one of the three DBMS_MVIEW
refresh procedures.”

当我调用DBMS_MVIEW.REFRESH(‘TESTRESULT’)时,发生了什么？它是否手动检查每条记录以查看它是否已更新？

Oracle版本：10g