ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12004：REFRESH FAST不能用于实例化视图“ string ”。“ string ”,
.原因：实例化视图日志不存在或无法使用。也未在物化视图上启用PCT刷新,
.操作：只使用REFRESH，它将重新启动整个表。如果存在物化视图日志，并且物化视图的形式允许在给定的一组更改后使用物化视图日志或PCT刷新，那么REFRESH FAST将在下次刷新物化视图时可用。,
.

aiaiDBA

13718043309

010-86462881

ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

1 个回答

相似问题