Re: extract data from a table with missing extents

From: ls cheng <g-e-n-o_at_europe.com>
Date: 5 Jan 2002 16:08:47 -0800
Message-ID: <b352e1b3.0201051608.10ba924a@posting.google.com>

Kort I know I dont have corrupted blocks but from Metalink forum one Oracle analyst actually suggest this was possible also in the same note it says that event 10231 can skip block SOFT corrupted, soft corrupted I guess it's missing blocks?

Jonathan I have that rowid note as well but I was wondering if event 10231 was possible

From Oracle Metalink's note 28814.1 Handing block corruption there was

"This is only possible in Oracle8i.
The aim is to mark the block as corrupt and then use the SKIP_CORRUPT table attribute to extract the table data: Use DBMS_REPAIR to mark the block corrupt <Note:68013.1>"

Stupid because when you click on 68301.1 it leads you to nowhere, another webIV paper, it's non-sense posting this link on such a popular paper, I was glad when I saw you could mark blocks corrupt with dbms_repair, anyway does anyone know how to do this with dbms_repair...? Received on Sat Jan 05 2002 - 18:08:47 CST