ORA-32414: materialized view logs are not compatible with each other for fast refresh

ORA-32414: materialized view logs are not compatible with each other for fast refresh
Cause: An attempt was made to create a fast refreshable materialized view on tables which have commit SCN-based materialized view logs and tables which have timestamp-based materialized view logs.
Action: Use COMPLETE REFRESH or change underlying materailized view logs to make them compatible with each other for fast refresh.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32414：物化视图日志彼此不兼容，用于快速刷新,
.原因：尝试在提交基于SCN的物化视图日志的表以及具有基于时间戳的物化视图日志的表上创建快速可刷新物化视图。,
.操作：使用COMPLETE REFRESH或更改底层设计视图日志，以使它们彼此兼容，以便快速刷新。,
.

aiaiDBA

13718043309

010-86462881

ORA-32414: materialized view logs are not compatible with each other for fast refresh

1 个回答

相似问题