Database DataWarehousing (MOSC)

MOSC Banner

Not able to create fast on commit materialized view with the following select query

edited Oct 19, 2013 8:39AM in Database DataWarehousing (MOSC) 5 commentsAnswered
getting error as ,

          *
ERROR at line 41:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view


  from GL.GL_CODE_COMBINATIONS GCC, --0317912,
          *
ERROR at line 41:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

ddl below,

create materialized view GL.MV_GL_JE_REPORT

refresh fast on commit

as

select GCC.ROWID as "GL.GL_CODE_COMBINATIONS_RID",

GJB.ROWID as "GL.GL_JE_BATCHES_RID",

GJCT.ROWID as "GL.GL_JE_CATEGORIES_TL_RID",

GJH.ROWID as "GL.GL_JE_HEADERS_RID",

GJL.ROWID as "GL.GL_JE_LINES_RID",

GJST.ROWID as "GL.GL_JE_SOURCES_TL_RID",

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