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@xxxxxxxxxxxxxxx

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Riku Räsänen
Sent: Wednesday, October 31, 2007 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: