Dear All,


When I tried to create a materialized view with this command ,

CREATE MATERIALIZED VIEW test_view
BUILD IMMEDIATE
REFRESH FORCE ON COMMIT
ENABLE QUERY REWRITE
AS
SELECT
cm012.cm012_nric_fin_no nric
FROM
cm012_mem_info_dtl cm012
UNION ALL
SELECT
ck020.ck020_nric_fin_no
FROM ck020_ppnt_parti_maint ck020; , I got the error

"ORA-30370: set operators are not supported in this context."

I want to refresh the materialized view on every commit on the master tables. Can this be achieved with the "union" clause by another method ??.

Thanks in advance

Louis.