Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 223 of 521
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.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|