Re: block corruption

This very old data not backed up but also not needed. Table is about 60gig so I dont want to have to do an export or a create table as select but cannot get repair to work

On 24/11/2008, David Ballester <ballester.david_at_gmail.com> wrote:
> 2008/11/24 Howard Latham <howard.latham_at_gmail.com>
>
>>
>>
>> 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.
>

-- 
Howard A. Latham
--
http://www.freelists.org/webpage/oracle-l