错误码 / Oracle Database

Oracle Database 错误码 ORA-12013

updatable materialized view must be simple enough and have a materialized view log on its master table to do fast refresh 原因:The updatable materialize…

错误说明

updatable materialized view must be simple enough and have a materialized view log on its master table to do fast refresh

原因:The updatable materialized view query contained a JOIN, SUBQUERY, UNION, CONNECT BY, ORDER BY, or GROUP BY clause, or the master table did not have a materialized view log.

处理:Make the materialized view simpler. If a join is really needed, make multiple simple materialized views then put a view on top of them. Make sure a materialized view log is created for the master table.

官方文档

进一步检索

相关错误码