This is always an ugly problem. And I am sure there are utilities to take
care of these things.... but for those of use who have to do things by the
manual method, this is what we ended up doing.
1. Do a select of the row_ids on the table in row_id order. When we found a
row_id bad record we then recorded this and then proceeded with a select
where the rowid_was greater than that one. Sometimes we had to try a few
IDs away from the bad one because they were all in bad blocks.
2. When the row_id select was done we then did a create to a temp table
based on the row_ids that were good from the bad table.
In this manner we new exactly the count of bad records based on how many
row_ids we skipped.
It was a very long weekend because this was a very large table we went thru.
But it worked out in the end.
-----Original Message-----
Sent: Tuesday, June 05, 2001 3:43 PM
To: Multiple recipients of list 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
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).
