ORA-12097: changes in the master tables during refresh, try refresh again

ORA-12097: changes in the master tables during refresh, try refresh again
Cause: There are some changes (i.e., conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.
Action: Refresh the affected materialized views again.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12097：刷新期间主表中的更改，请再次尝试刷新,
.原因：在物化视图刷新期间，主表中有一些更改（即，常规DML，直接装载，分区维护操作）。,
.操作：再次刷新受影响的实例化视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-12097: changes in the master tables during refresh, try refresh again

1 个回答

相似问题