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

From: kathy duret <katpopins21_at_yahoo.com>
Date: Wed, 31 Oct 2007 10:17:46 -0700 (PDT)
Message-ID: <4445.21425.qm@web38213.mail.mud.yahoo.com>

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

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 31 2007 - 12:17:46 CDT