Re: Cause for index corruption, Metalink Note Id 457021.1?

You could be hitting a correct block or even a bad sector on a disk.
   
  Try to rebuild to another tablespace....
   
  K

Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx> wrote:
  Hi,

Customer is apparently hitting index corruption, or more likely data 
dictionary corruption, as documented in Metalink Note Id 457021.1. Any 
ideas, what is causing this corruption? Any usual suspects?

Oracle SE 9.2.0.8, regular multi-column index. Apparently no index 
rebuilds done, indexes are validated every now and then. The corruption 
has hit this same index twice. No error messages anywhere, the query using 
the index just does not return any data.

TIA,



-- 
Riku
--
http://www.freelists.org/webpage/oracle-l




 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

Other related posts: