标题: ORA-12047: PCT FAST REFRESH cannot be used for materialized view [打印本页] 作者: admin 时间: 2016-8-5 10:01 标题: ORA-12047: PCT FAST REFRESH cannot be used for materialized view ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string" Cause: PCT refresh is eithernot enabled on this materialized view or not possible
after set of the base table changes since last refresh. Action: Use just REFRESHFORCE, which will reinstantiate the entire table and
try to pick the best refresh method on the materialized view Do explain_mviewto
look at the cause why PCT refresh is not possible on this materialized view