标题: ORA-12030: cannot create a fast refresh materialized view [打印本页] 作者: admin 时间: 2016-8-5 09:55 标题: ORA-12030: cannot create a fast refresh materialized view ORA-12030: cannot create a fast refresh materialized view Cause: The materialized viewlog did not exist or did not log the information
needed by the materialized view to perform a fast refresh. 8-30 Oracle Database ErrorMessages Action: Ensure that thematerialized 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.