Thursday, February 19, 2015
ORA-00942 while creating materialized view
I hit following problem while creating the materialized view with option refresh fast although SCHEMA2.TABNAME exists and SCHEMA1 user has select privilege on it
CREATE MATERIALIZED VIEW SCHEMA1.MVIEW ....
SELECT .... FROM SCHEMA2.TABNAME....
ORA-12018: following error encountered during code generation for "SCHEMA1"."MVIEW "
ORA-00942: table or view does not exist
Problem is not the source table itself but the materialized view log table created before. In order to solve the problem you should identify materialized view log table and give select permission to materialized view owner
select LOG_TABLE from ALL_MVIEW_LOGS where log_owner=' SCHEMA2' and master='TABNAME'
grant select on SCHEMA2.LOG_TABLE to SCHEMA1;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment