[MV] - Oracle 18.104.22.168 (Needs_compile)
From a complex query with sub-select, analytic function (LAG, LEAD,...) I've create a materialized view with query rewrite option enabled.
My problem as follow : Each refresh of MV failed with an error in
ALL_MVIEWS ; the column 'COMPILE_STAT' is set to NEEDS_COMPILE.
I read the documentation about this error and it say, this error happened when a componant/depedency of MV has been modified by a not DML statement. But I'm no modified anything.
When the next refresh has happened, I can't you see the new data in the view... just 'NEEDS_COMPILE'
If I try a manual refresh it's ok, when i compile view via an 'alter
mat. view' ... it's ok...
any idea to fix this 'bug' ??
Last edited by jacquesh; 11-17-2006 at 11:04 AM.
Click Here to Expand Forum to Full Width