DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Mview

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    Mview

    Hi all,
    I just refreshed my Mview. checked the status but it came up as UNUSABLE. Apart from re-running the refresh, what could be the issue?.
    Two other mviews were refreshed off the same base table and there OK.
    Thanks
    Looking for the greatest evil in the world? Look in the mirror.

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    What error you are getting when trying to use it?

  3. #3
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Didn't rewrite. Ok now. re-refreshed it...
    Looking for the greatest evil in the world? Look in the mirror.

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