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

[skdas]

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

[davey23uk]

define corrupted?

[skdas]

define corrupted?

What do you mean by this..???

[davey23uk]

what do you mean by corrupted

[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..

[gandolf989]

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?

[davey23uk]

YOU have to explain what YOU think corrupted means

[graham_o]

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

[skdas]

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..