Re: Extract data from index

Peter Mubaiter <this.is.not.valid_at_spammer.hola> wrote:
> 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,

How about doing an "order by" possibly with one of the hints I'm too lazy to look up and which may not even exist in your version (index_asc?) to see if you can get it to follow the linked list through the leaves, rather than following the index tree?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB