block corruption

From: Howard Latham <>
Date: Mon, 24 Nov 2008 13:22:36 +0000
Message-ID: <>

I have a table with some corrupt blocks- fortunately the related rows are not needed
as it is very historic data.

Unfortunately when I try to execute the
DBMS_REPAIR.fix_corrupt_block procedure I get an ORA-01578 - which is rather annoyingly
the "you have corrupt blocks message". Surely this message shouldn't happen when
you are trying to flag the blocks as corrupt? I have looked in the output table REPAIR_TABLE
there is no output so its not a case of 'just ignore the message'

OS REDHAT Linux Oracle 10g


Howard A. Latham
Senior DBA
RSMB Television Research.

-- Received on Mon Nov 24 2008 - 07:22:36 CST

Original text of this message