错误码 / 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.