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

What's the query?

Is it a function based index?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Riku Räsänen Sent: Wednesday, October 31, 2007 10:57 AM To: oracle-l_at_freelists.org
Subject: Cause for index corruption, Metalink Note Id 457021.1?

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 31 2007 - 11:13:34 CDT