ORA-12004: REFRESH FAST cannot be used for materialized view “string”.”string”
Cause: The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view
Action: Use just REFRESH, which will reinstantiate the entire table. If a materialized view log exists and the form of the materialized view allows the use of a materialized view log or PCT refresh is possible after a given set of changes, REFRESH FAST will be available starting the next time the materialized view is refreshed.
ORA-12004表示无法用REFRESH FAST来刷新指定的物化视图。该错误码通常是由一个不允许使用REESH FAST刷新的物化视图来触发,这通常发生在要刷新的物化视图被定义为不允许使用REESH FAST来刷新的物化视图。
ORA-12004表示无法用快速方式刷新给定的物化视图。发生这个错误的原因是指定的物化视图定义为不能用REESH FAST来刷新。
ORA-12004错误经常发生在用户想CRASH FAST刷新对象时,但该对象本身定义为不可以使用REESH FAST刷新。
•确认是否已有一个物化视图定义为不可以使用REESH FAST刷新。
•如果没有,那么检查有无错误的物化视图定义。
•如果有,那么检查REESH FAST是否允许刷新有问题的物理视图,如果没有允许,那么修改物理视图的定义来允许REESH FAST的刷新。