Create materialized view fast refresh >>>> ora-12054
I would create materialized view FAST refresh on commit.
1 - I have created :
*****create materialized view log on WTRUN2.ARTICLE with sequence, rowid
( NUMERO, IDA2A2, REVISION,ITERATION, etat )
including new values;***** create materialized view log on WTRUN2.LIENARTICLEVUE with sequence, rowid
(IDA2A2_ARTICLE ,VUE_AFFICHAGE_VUE ) including new values;
2 - When Created Materialized view next ; >>>>> error : ORA-12054
I do not understand why; how may trace and log my problem ?
CREATE MATERIALIZED VIEW WTRUN2.MV_ARTICLE_DESIGN_LATEST
BUILD IMMEDIATE
REFresh fast on commit
USING DEFAULT LOCAL ROLLBACK SEGMENT
ENABLE QUERY REWRITE
AS ( SELECT NUMERO, IDA2A2, rowid