ORA-12067: empty refresh groups are not allowed ORACLE 报错 故障修复 远程处理
文档解释
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.然后再执行相应的引用更新操作。
