5.285 DBA_REPAIR_TABLE

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 the DBMS_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(128)

NOT NULL

Schema of the corrupt object

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the corrupt object

BASEOBJECT_NAME

VARCHAR2(128)

NULL

If the object is an index, the name of its base table

PARTITION_NAME

VARCHAR2(128)

NULL

Partition or subpartition name, if applicable

CORRUPT_DESCRIPTION

VARCHAR2(2000)

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

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_REPAIR package