Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: How Oracle handle index crash?

    Suppose this situation:Index is damaged (bad blocks or sth like this).
    Is there any possibility to tell Oracle:Well,rebuild damaged indexes yourself (automatically)?
    I ask because DB2 know for this option.
    Thanks for Your advice,
    Zvonimir

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Don't believe so. Oracle marks the index as corrupt an all_indexes (I think thats the right system view), and will not use it - but it will not rebuild it automatically
    Regards
    Dbabren

Posting Permissions

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