DBA_REPAIR_TABLE describes any corruptions found by the DBMS_REPAIR.CHECK_OBJECT procedure. This information is used by the DBMS_REPAIR.FIX_CORRUPT_BLOCKS procedure on execution. To create this view, first run the DBMS_REPAIR.ADMIN_TABLES procedure. To populate the resulting repair table for an object, run the DBMS_REPAIR.CHECK_OBJECT procedure on the object.
Note:
The table created by theDBMS_REPAIR.ADMIN_TABLES procedure is called REPAIR TABLE by default. If you specify a different name, this view will have the name you specify, preceded by "DBA_REPAIR_".| Column | Datatype | NULL | Description |
|---|---|---|---|
OBJECT_ID |
NUMBER |
NOT NULL |
Dictionary object number of the object with the corruption |
TABLESPACE_ID |
NUMBER |
NOT NULL |
Tablespace number of the corrupt object |
RELATIVE_FILE_ID |
NUMBER) |
NOT NULL |
Relative file number of the corrupt object |
BLOCK_ID |
NUMBER |
NOT NULL |
Block number of the corruption |
CORRUPT_TYPE |
NUMBER |
NOT NULL |
Type of corruption encountered |
SCHEMA_NAME |
VARCHAR2(30) |
NOT NULL |
Schema of the corrupt object |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the corrupt object |
BASEOBJECT_NAME |
VARCHAR2(30) |
NULL |
If the object is an index, the name of its base table |
PARTITION_NAME |
VARCHAR2(30) |
NULL |
Partition or subpartition name, if applicable |
CORRUPT_DESCRIPTION |
VARCHAR2(200) |
NULL |
Description of corruption |
REPAIR_DESCRIPTION |
VARCHAR2(200) |
NULL |
Description of repair action |
MARKED_CORRUPT |
VARCHAR2(10) |
NOT NULL |
Whether the block is marked corrupt (TRUE | FALSE) |
CHECK_TIMESTAMP |
DATE |
NOT NULL |
Date and time when this row was insert into the repair table |
FIX_TIMESTAMP |
DATE |
NULL |
Date and time when the block was modified by the FIX_CORRUPT_BLOCKS procedure, if applicable |
REFORMAT_TIMESTAMP |
DATE |
NULL |
Reserved for future use |