Cause for index corruption, Metalink Note Id 457021.1?
- From: Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 17:57:02 +0200
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
- Follow-Ups:
- RE: Cause for index corruption, Metalink Note Id 457021.1?
- From: Taylor, Chris David
- Re: Cause for index corruption, Metalink Note Id 457021.1?
- From: kathy duret
Other related posts:
- » Cause for index corruption, Metalink Note Id 457021.1?
- » RE: Cause for index corruption, Metalink Note Id 457021.1?
- » Re: Cause for index corruption, Metalink Note Id 457021.1?
- RE: Cause for index corruption, Metalink Note Id 457021.1?
- From: Taylor, Chris David
- Re: Cause for index corruption, Metalink Note Id 457021.1?
- From: kathy duret