Error creating a materialized view
Hi All,
Trying to create a materialized view as below but getting the below error;
CREATE MATERIALIZED VIEW CUSTOMER_MV
PARALLEL 4 NOLOGGING CACHE BUILD IMMEDIATE REFRESH WITH PRIMARY KEY
FAST ON COMMIT
ENABLE QUERY REWRITE
AS
SELECT DISTINCT a.aian8 , a.wwmlnm , a.wwnick , a.abalph , a.MAPA8 ,
a.ABALPH , d.MAPA8, a.abalph,a.ALADD1, a.ALADD2, a.ALADD3 , a.ALADD4 ,
b.WPAR1 , b.WPPH1, c.eaemal, a.aiDAOJ,a.aicustS, a.abtx2, a.abtax , a.wwrem1, a.alctr
FROM (SELECT aian8,wwmlnm,wwnick,abalph,mapa8,aladd1,aladd2,aladd3,aladd4,aiDAOJ,aicusts,abtx2,abtax,wwrem1,alctr
FROM CRPDTA.F03012, CRPDTA.F0101, CRPDTA.F0111,CRPDTA.F0150, CRPDTA.F0116