2008/11/24 Howard Latham <howard.latham@xxxxxxxxx> > > > for clarity THIS is what I am running > > SET SERVEROUTPUT ON > DECLARE num_corrupt INT; > BEGIN > num_corrupt := 0; > DBMS_REPAIR.CHECK_OBJECT ( > SCHEMA_NAME => 'SCOTT', > OBJECT_NAME => 'DEPT', > > REPAIR_TABLE_NAME => 'REPAIR_TABLE', > CORRUPT_COUNT => num_corrupt); > DBMS_OUTPUT.PUT_LINE('number corrupt: ' || TO_CHAR (num_corrupt)); > END; > / > > Hi: If you're in archive log mode use rman to repair exclusively these corrupted blocks http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/ Regards D.