Re: block corruption

From: Howard Latham <howard.latham_at_gmail.com>
Date: Mon, 24 Nov 2008 13:25:12 +0000
Message-ID: <713d96d10811240525s35235028l952aeeb9492c460f@mail.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;
/

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 24 2008 - 07:25:12 CST