Hi,

I have this error when creating mv.
Any help is appreciated.

Thnks

SQL> CREATE MATERIALIZED VIEW S42LD.LDMV_CONTRACT_FIN_DTL
2 TABLESPACE S42LD_DATA
3 NOCACHE
4 LOGGING
5 NOCOMPRESS
6 PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT )
7 BUILD IMMEDIATE
8 REFRESH FORCE ON DEMAND
9 WITH PRIMARY KEY
10 ENABLE QUERY REWRITE
11 AS
12 (
13 SELECT f.*
14 FROM LDV_CONTRACT_FIN_DTL f <<<< OK here - single table
15 );

Materialized view created.



1 CREATE MATERIALIZED VIEW S42LD.LDMV_CONTRACT_FIN_DTL2
2 TABLESPACE S42LD_DATA
3 NOCACHE
4 LOGGING
5 NOCOMPRESS
6 PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT )
7 BUILD IMMEDIATE
8 REFRESH FORCE ON DEMAND
9 WITH PRIMARY KEY
10 ENABLE QUERY REWRITE
11 AS
12 (
13 SELECT f.*,p.party_id cpty_id ,name cpty
14 FROM LDV_CONTRACT_FIN_DTL f <<<< ERROR ????
15 ,axiom.contract c, axiom.party p
16 where c.cparty_id = p.party_id
17 and c.contract_id = f.contract_id
18* )
SQL> /
FROM LDV_CONTRACT_FIN_DTL f
*
ERROR at line 14:
ORA-01031: insufficient privileges


SQL>