ORA-12030: cannot create a fast refresh materialized view

ORA-12030: cannot create a fast refresh materialized view
Cause: The materialized view log did not exist or did not log the information needed by the materialized view to perform a fast refresh.
Action: Ensure that the materialized view log exists and logs the necessary information.
- For ROWID materialized views, the master table's ROWID must be logged.

- For primary key materialized views, the master table's primary key columns must be logged.

- For subquery materialized views, the filter columns, primary key, and ROWID values must be logged.

- For object materialized views, object id must be logged.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12030：无法创建快速刷新实例化视图,
.原因：物化视图日志不存在，或者未记录物化视图执行快速刷新所需的信息。,
.操作：确保物化视图日志存在，并记录必要的信息。,
.- 对于ROWID物化视图，必须记录主表的ROWID。,
.,
.- 对于主键实例化视图，必须记录主表的主键列。,
.,
.- 对于子查询物化视图，必须记录筛选器列，主键和ROWID值。,
.,
.- 对于对象物化视图，必须记录对象标识。,
.,
.

aiaiDBA

13718043309

010-86462881

ORA-12030: cannot create a fast refresh materialized view

1 个回答

相似问题