重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-32414: materialized view logs are not compatible with [打印本页]

作者: michaeljet 时间: 2016-9-1 16:19
标题: ORA-32414: materialized view logs are not compatible with

ORA-32414: materialized view logs are notcompatible with each other for fast

refresh

Cause: An attempt was made to createa fast refreshable materialized view on

tables which have commit SCN-based materialized view logsand tables which

have timestamp-based materialized view logs.

Action: Use COMPLETE REFRESH or changeunderlying materailized view logs

to make them compatible with each other for fast refresh.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)