DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2006

    Exclamation [MV] - Oracle (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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

By using this site, you agree to the Privacy Policy