5.223 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(128)

NOT NULL

Schema name of the index

INDEX_NAME

VARCHAR2(128)

NOT NULL

Name of the index

IPART_NAME

VARCHAR2(128)

NULL

Name of the index partition or subpartition

INDEX_ID

NUMBER

NOT NULL

Dictionary object ID of the index

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the base table of the index

PART_NAME

VARCHAR2(128)

NULL

Name of the base table partition or subpartition

TABLE_ID

NUMBER

NOT NULL

Dictionary object ID of the base table

KEYROWID

ROWID

NOT NULL

Physical rowid of the corrupt data row

KEY

ROWID

NOT NULL

Key values for the index entry

DUMP_TIMESTAMP

DATE

NOT NULL

Timestamp when the entry was made into the orphan key table