My Oracle Support Banner

OERR: ORA-8102 "index key not found, obj# %s, file %s, block %s (%s)" (Doc ID 8102.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 7.0.16.0 to 12.1.0.2 [Release 7.0 to 12.1]
Oracle Database - Standard Edition - Version 7.0.16.0 to 12.1.0.2 [Release 7.0 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This article provides information about error ORA-8102 and possible actions.

Scope

This note is intended for general audience as initial starting point for beginning diagnosis of ORA-8102.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Description
 What index is affected?
 Cause
 Oracle defect.
 Block corruption in the index or in the table.
 Hardware / IO.
 ORA-8102 and Function-based indexes (FBI)
 Solution
 How to disable automatic Redo Dump when there is an ORA-8102?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.