Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: - NEEDS_COMPILE Problem
in my previous post replace NEEDS_VALUE by NEEDS_COMPILE...
no more idea ?
On 17 nov, 10:58, "jacquesh" <jhu..._at_gmail.com> wrote:
> 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_VALUE.
>
> 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.
Received on Sat Nov 18 2006 - 05:20:58 CST