[MATERILZED VIEW] - NEEDS_COMPILE Problem

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 Fri Nov 17 2006 - 03:58:06 CST