Re: How to remove corrupted blocks from datafile.

I think you have to recreate all the tables in another datafile then drop that corrupted datafile.

At 12:42 PM 6/5/01 -0800, you wrote:
>Hi,
>I found some corrupted blocks in one of the datafile. I have created the
>temp table by select all the records (excluding the records in corrupted
>blocks) from corrupted table, and dropped the table, renamed the temp table
>back to original. After this when i run DBV on that file, it still shows
>there are some corrupted blocks in the file. i have two questions,
>
>1> How do i calculate how many records i have lost?
>2> How do i remove corrupted blocks from the blocks?
>
>Can anyone tell me ...
>Thanks in advance
>Uday
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hal Wigoda
  INET: hwigoda_at_mcs.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).