-
How to know if one index is corrupted or not..?
How to know if one index is corrupted or not..?
-
-
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..
-
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?
-
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
Last edited by graham_o; 04-26-2006 at 11:59 AM.
Reason: oops - forgot the link
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|