Ora-4045: what could cause Materialized View to 'NEEDS_COMPILE'?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-4045: what could cause Materialized View to 'NEEDS_COMPILE'?

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    Ora-4045: what could cause Materialized View to 'NEEDS_COMPILE'?

    We got ora-4045 while running a query again a materialized view. It seems the Materialized View needs to be compiled.
    According to Oracle: 'A materialized view is automatically revalidated when it is referenced'. We only had DML on the base tables.
    So when the materialized views will be 'automatically revalidated' and when they will not and we get ora-4045?

    Thanks!

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Version? See bug 2660521.

    Anything in alertlog?

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    9.2.0.6. There is nothing in alert.log file. I used bug number here to check in metalink, there is nothing showing there.

    Thanks!

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    I can pull it up using bug search. Anyway, it had to do with 8i, 9.0.1..so might not be applicable to you.

    In addition, do a regular search with the bug number to see a few more articles.

    PS : I have no other ideas, if you see no errors in the alertlog. I would imagine the ORA-4045 means that the underlying materialized view is itself invalid. But with no accompanying errors in the alertlog, I'm not sure how to go about this either.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Sorry, nothing much to add - I'm kind of "pinging" the thread.

    In 8.1.7 I have refresh on demand MV's that always show as INVALID. However they work perfectly well, give the right answer. I'd like to understand why.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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