Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to remove corrupted blocks from datafile.

How to remove corrupted blocks from datafile.

From: udaycb <udaycb_at_trwasp.com>
Date: Tue, 05 Jun 2001 12:43:27 -0700
Message-ID: <F001.0031CCEE.20010605124253@fatcity.com> 





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





Received on Tue Jun 05 2001 - 14:43:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US