Re: How to remove corrupted blocks from datafile.

[Diana_Duncan]

When this has happened to me in the past, I've done exactly as you did, but
in addition I renamed the table with the bad blocks to something like
BAD_<table>, and just left it there.  That way, the blocks weren't reused.
Not elegant, but it worked...

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


                                                                                       
                            
                    "udaycb"                                                           
                            
                    <udaycb@trwas        To:     Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>       
                    p.com>               cc:                                           
                            
                    Sent by:             Fax to:                                       
                            
                    root@fatcity.        Subject:     How to remove corrupted blocks 
from datafile.                
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    06/05/2001                                                         
                            
                    04:42 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L                                                           
                            
                                                                                       
                            
                                                                                       
                            




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

(See attached file: winmail.dat)

winmail.dat