Block corruption
764175Apr 1 2010 — edited Apr 2 2010Hi,
DBV show me this corruption:
DBVERIFY - Verification starting : FILE = /database/prova.dbf
Block Checking: DBA = 30108565, Block Type = KTB-managed data block
data header at 0x2a96e57324
kdbchk: the amount of space used is not equal to block size
used=7173 fsc=0 avsp=776 dtl=7896
Page 748437 failed with check code 6110
Block Checking: DBA = 30658003, Block Type = KTB-managed data block
data header at 0x2a96ed354c
kdbchk: the amount of space used is not equal to block size
used=7107 fsc=0 avsp=501 dtl=7344
Page 1297875 failed with check code 6110
I would like to know which rows (or rowid) contains block corrupt.
I used Select dbms_utility.data_block_address_file and dbms_utility.data_block_address_block and
SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAME
FROM DBA_EXTENTS
WHERE FILE_ID = 6
AND &block BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
to determine which table is corrupted.
thank you,
Davide