jacquesh 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.
No DDL
No error message
No version
No help possible
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Nov 19 2006 - 12:42:03 CST
