I have the following query

SQL> CREATE MATERIALIZED view testuninmv
2 tablespace interface
3 BUILD DEFERRED
4 ENABLE QUERY REWRITE
5 as
6 select eno from emp
7 Union
8 select eno from dept
9 /
CREATE MATERIALIZED view testuninmv
*
ERROR at line 1:
ORA-30370: set operators are not supported in this context

Im not sure how to handle this situation.

There is a need for me to create a materialized view on a query which involves Union operator !!!!!

Plz help.

-Indu