SQL Language (MOSC)

MOSC Banner

Error creating a materialized view

edited Aug 9, 2016 5:00AM in SQL Language (MOSC) 1 commentAnswered

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   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center