-
[MV] - Oracle 8.1.7.4 (Needs_compile)
Hello
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' ??
thanks.
Last edited by jacquesh; 11-17-2006 at 12:04 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|