General Restrictions on Fast Refresh The defining query of the materialized view is restricted as follows: The materialized view must not contain references to non-repeating expressions like SYSDATE and ROWNUM. The materialized view must not contain references to RAW or LONG RAW data types. It cannot contain a SELECT list subquery. It cannot contain analytical functions (for example, RANK) in the SELECT clause. It cannot contain a MODEL clause. It cannot contain a HAVING clause with a subquery. It cannot contain nested queries that have ANY, ALL, or NOT EXISTS. It cannot contain a [START WITH …] CONNECT BY clause. It cannot contain multiple detail tables at different sites. On-commit materialized view cannot have remote detail tables. Nested materialized views must have a join or aggregate.
Oracle物化视图刷新方式on commit
最新推荐文章于 2022-07-31 11:11:45 发布