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

Thread: How to know if one index is corrupted or not..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know if one index is corrupted or not..?

    How to know if one index is corrupted or not..?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    define corrupted?

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    define corrupted?

    What do you mean by this..???

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what do you mean by corrupted

  5. #5
    Join Date
    Jul 2002
    Posts
    205
    HI davey23uk ,

    I have one index names I1, my question is how to find out if it is corrupted. Can you pls little bit elaborate the steps. What ever you wrote it is not clear.

    Thanks..

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by skdas
    HI davey23uk ,

    I have one index names I1, my question is how to find out if it is corrupted. Can you pls little bit elaborate the steps. What ever you wrote it is not clear.

    Thanks..
    Indexes do not normally get corrupted. You can turn on index monitoring to see which indexes get used, and you can analyze your indexes. Why do you think you have a corrupted index?

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    YOU have to explain what YOU think corrupted means

  8. #8
    Join Date
    Apr 2006
    Posts
    50
    follow this link to Tim Hall's site. It not only covers the

    alter index index_name validate structure

    command to detect invalid / corrupt indexes but also repair methods too.

    http://www.oracle-base.com/articles/...Corruption.php
    Last edited by graham_o; 04-26-2006 at 11:59 AM. Reason: oops - forgot the link

  9. #9
    Join Date
    Jul 2002
    Posts
    205
    HI davey23uk,

    See the answer of graham_o. I was looking for something like this. If you are not sure of anything, please do not misguide others, let other people answer it.

    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
  •  


Click Here to Expand Forum to Full Width