DBA_ORPHAN_KEY_TABLE

DBA_ORPHAN_KEY_TABLE reports key values from indexes where the underlying base table has block corruptions. To create the view, run the DBMS_REPAIR.ADMIN_TABLES procedure. To populate the orphan key table for an index, run the DBMS_REPAIR.DUMP_ORPHAN_KEYS procedure on the index. For each key in the index that points to a corrupt data block, Oracle inserts a row into the orphan key table.

Column Datatype NULL Description
SCHEMA_NAME VARCHAR2(30) NOT NULL Schema name of the index
INDEX_NAME VARCHAR2(30) NOT NULL Name of the index
IPART_NAME VARCHAR2(30) NULL Name of the index partition or subpartition
INDEX_ID NUMBER NOT NULL Dictionary object ID of the index
TABLE_NAME VARCHAR2(30) NOT NULL Name of the base table of the index
PART_NAME VARCHAR2(30) NULL Name of the base table partition or subpartition
TABLE_ID NUMBER NOT NULL Dictionary object ID of the base table
KEYDATA UROWID NOT NULL Physical rowid of the corrupt data row
KEY UROWID NOT NULL Key values for the index entry
DUMP_TIMESTAMP DATE NOT NULL Timestamp when the entry was made into the orphan key table