Database DataWarehousing (MOSC)

MOSC Banner

Create materialized view fast refresh >>>> ora-12054

edited Mar 31, 2011 2:40AM in Database DataWarehousing (MOSC) 10 commentsAnswered
 hello,

   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

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