Materialized Views: MINUS, EXCEPT, and INTERSECT No Longer Allowed¶

In the current release, you are not allowed to use the MINUS (or EXCEPT) and INTERSECT set operators in a materialized view.

Previously:

You could create, alter, or query a materialized view that uses the MINUS, EXCEPT, or INTERSECT operator.

Currently:

Creating, altering, or querying a materialized view that uses the MINUS, EXCEPT, or INTERSECT operator results in one of the following error messages:

Invalid materialized view definition. Join types [MINUS] not allowed in view definition.

Invalid materialized view definition. Join types [INTERSECT] not allowed in view definition.

If you previously had a materialized view that used the MINUS, EXCEPT, or INTERSECT operator, recreate that materialized view so that it no longer uses the MINUS, EXCEPT, or INTERSECT operator.

Ref: 215, 757