Cause for index corruption, Metalink Note Id 457021.1?

From: Riku Räsänen <riku.rasanen_at_kantamestarit.fi>
Date: Wed, 31 Oct 2007 17:57:02 +0200
Message-ID: <op.t02jxckdrkn1vh@smtp.saunalahti.fi>

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 Received on Wed Oct 31 2007 - 10:57:02 CDT