Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPAIR, 3 of 8
This procedure checks the specified objects and populates the repair table with information about corruptions and repair directives.
Validation consists of block checking all blocks in the object. You may optionally specify a DBA range, partition name, or subpartition name when you want to check a portion of an object.
DBMS_REPAIR.CHECK_OBJECT ( schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT, repair_table_name IN VARCHAR2 DEFAULT 'REPAIR_TABLE', flags IN BINARY_INTEGER DEFAULT NULL, relative_fno IN BINARY_INTEGER DEFAULT NULL, block_start IN BINARY_INTEGER DEFAULT NULL, block_end IN BINARY_INTEGER DEFAULT NULL, corrupt_count OUT BINARY_INTEGER);
Parameter | Description |
---|---|
schema_name |
Schema name of the object to be checked. |
object_name |
Name of the table or index to be checked. |
partition_name |
Partition or subpartition name to be checked.
If this is a partitioned object, and if |
object_type |
Type of the object to be processed. This must be either See "Enumeration Types". |
repair_table_name |
Name of the repair table to be populated.
The table must exist in the |
flags |
Reserved for future use. |
relative_fno |
Relative file number: Used when specifying a block range. |
block_start |
First block to process if specifying a block range. May be specified only if the object is a single table, partition, or subpartition. |
block_end |
Last block to process if specifying a block range. May be specified only if the object is a single table, partition, or subpartition. If only one of |
corrupt_count |
Number of corruptions reported. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|