Block Repair with Oracle 8i DBV utility

[homayar]

The dbverify utility in Oracle 8i shows me that pages corrupt 1. Now in the dbms package for block repair and populating the repair table, you need to pass the IN parameter values of OBJECT NAME and SCHEMA NAME. Finding the schema name is ok but through which view one can find out the object name which holds that corrupt block ?

[np70]

Find out file number using dba_data_files. --> PX

Not the page no. (block no.) where dbv failed. --> BX

Now user dba_extents view to query which object is effected.

e.g.

select segment_name from dba_extents
where file_id = PX
and BX between block_id and block_id+blocks-1;

HTH

np70