Not able to create fast on commit materialized view with the following select query
*
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",