Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to remove corrupted blocks from datafile.
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: Diana_Duncan_at_ttpartners.com
"udaycb" <udaycb_at_trwas To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> p.com> cc: Sent by: Fax to: root_at_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)
Received on Tue Jun 05 2001 - 19:43:55 CDT
![]() |
![]() |