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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
