Re: Extract data from index

From: Peter Mubaiter <this.is.not.valid_at_spammer.hola>
Date: Fri, 14 Jan 2005 20:18:18 +0100
Message-ID: <1105730324.4152228b0c945dba5fd2537d36cf8a6c@teranews>

xhoster_at_gmail.com wrote:

> Have you tried something like:
>
> select /*+ index (c INDEX_NAME)*/ indexed_column
> from affected_table where indexed_column is not null
> and indexed_column > 'Oopsie';
>
> Where 'Oopsie' would be an value just after the values stored in the block
> with the suspected corruption?

Yes, I tried. Unfortunately I just discovered that the corrupted block is a node, not a leaf. I think, I'll forget about this column...

Thanks all for your help,

Peter Received on Fri Jan 14 2005 - 13:18:18 CST