ORA-12067: empty refresh groups are not allowed

文档解释

ORA-12067: empty refresh groups are not allowed

Cause: The refresh group being instantiated did not contain any materialized views.

Action: Modify the template to include at least one materialized view.

ORA-12067 消息告诉您,不允许创建一个空的自动刷新组。

官方解释

ORA-12067: empty refresh groups are not allowed

Cause: An attempt was made to create an empty refresh group.

Action: A refresh group must contain one or more materialized views.

常见案例

一般情况下,在创建一个物化视图组时,用户可能会忘记添加物化视图,从而创建一个空视图组。

正常处理方法及步骤

1.删除该空视图组;

2.重新创建一个该组,并确保在创建时,必须添加一个或多个物化视图;

3.然后再执行相应的引用更新操作。

你可能感兴趣的