Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Static Data Dictionary Views, 301 of 625
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, 2002 Oracle Corporation. All Rights Reserved. |
|