How to know if one index is corrupted or not..?
Printable View
How to know if one index is corrupted or not..?
define corrupted?
define corrupted?
What do you mean by this..???
what do you mean by corrupted
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?Quote:
Originally Posted by skdas
YOU have to explain what YOU think corrupted means
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
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..