Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPAIR, 4 of 8
This procedure reports on index entries that point to rows in corrupt data blocks. For each such index entry encountered, a row is inserted into the specified orphan table.
If the repair table is specified, then any corrupt blocks associated with the base table are handled in addition to all data blocks that are marked software corrupt. Otherwise, only blocks that are marked corrupt are handled.
This information may be useful for rebuilding lost rows in the table and for diagnostic purposes.
DBMS_REPAIR.DUMP_ORPHAN_KEYS ( schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, object_type IN BINARY_INTEGER DEFAULT INDEX_OBJECT, repair_table_name IN VARCHAR2 DEFAULT 'REPAIR_TABLE', orphan_table_name IN VARCHAR2 DEFAULT 'ORPHAN_KEYS_TABLE', flags IN BINARY_INTEGER DEFAULT NULL, key_count OUT BINARY_INTEGER);
Parameter | Description |
---|---|
schema_name |
Schema name. |
object_name |
Object name. |
partition_name |
Partition or subpartition name to be processed.
If this is a partitioned object, and if |
object_type |
Type of the object to be processed. The default is See "Enumeration Types". |
repair_table_name |
Name of the repair table that has information regarding corrupt blocks in the base table.
The specified table must exist in the |
orphan_table_name |
Name of the orphan key table to populate with information regarding each index entry that refers to a row in a corrupt data block.
The specified table must exist in the |
flags |
Reserved for future use. |
key_count |
Number of index entries processed. |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|