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 of the index |
|
|
|
Name of the index |
|
|
|
Name of the index partition or subpartition |
|
|
|
Dictionary object ID of the index |
|
|
|
Name of the base table of the index |
|
|
|
Name of the base table partition or subpartition |
|
|
|
Dictionary object ID of the base table |
|
|
|
Physical rowid of the corrupt data row |
|
|
|
Key values for the index entry |
|
|
|
Timestamp when the entry was made into the orphan key table |