Extract data from index

Suppose the following situation:

You have got an 8.0.5 database with an index which has a corrupted block. The table on which the index was created does not exist anymore, due to a storage hardware failure. Only the index tablespace is left. What you want to do now, is

select /*+ index (c INDEX_NAME)*/ indexed_column

   from affected_table where indexed_column is not null;

to get all the data from the index (to save as much data as possible). Unfortunately there is a corrupted block in this index. The question is now: Can you navigate around the corrupted block? Possibly with dirty tricks like changes in the data dictionary?

Thanks for any ideas,

Peter Received on Thu Jan 13 2005 - 10:10:52 CST