Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Snapshots getting "Invalid"

    Hi!

    Out of around 100s of snapshots that I have in my database there are three snapshots that are getting "Invalid" after every 4-5 days.

    They have to be dropped and recreated everytime they are found in "Invalid" state.

    There is no change made for the associated master tables at master site.

    Can anyone help me with any possible reason for this.

    Thanks !

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    are you talking about Materialized Views?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    87
    Yes, they were created with "CREATE Snapshot" statement though.
    Thanks.

Posting Permissions

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