错误码：-2553
错误内容：快速刷新物化视图不能含有除UNION ALL外的集合运算
错误级别: ERROR
原因：物化视图不支持快速刷新

CREATE MATERIALIZED VIEW MV4 REFRESH WITH PRIMARY KEY FAST AS
SELECT * FROM ITS.EMP WHERE EMPNO=7369
UNION
SELECT * FROM ITS.EMP WHERE EMPNO=7499


-2553: 第4 行附近出现错误:
快速刷新物化视图不能含有除UNION ALL外的集合运算

解决方法

CREATE MATERIALIZED VIEW MV3 REFRESH WITH PRIMARY KEY COMPLETE AS
SELECT * FROM ITS.EMP WHERE EMPNO=7369
UNION
SELECT * FROM ITS.EMP WHERE EMPNO=7499