Re: Obtain the ROWID from a index block

To follow up after a little investigation

I remebered that all index entries are unique even for non-unique indexes. For non-unique indexes the ROWID is concatenated to the entry as in my example (which was a non-unique index) so

col 1; len 6; (6): 08 80 4d 19 00 00

does represent the ROWID

bob

bobde6_at_hotmail.com wrote:
> Hi Sybrand - Thanks for the reply
>
> The index dump is for a single column index on an integer value
>
> e.g.] "c3 07 39 39" -> 65656
>
> My assumption is that a index entry holds the value and the
assoicated
> ROWID
>
> Bob
>
> Sybrand Bakker wrote:
> > On 1 Mar 2005 07:53:03 -0800, bobde6_at_hotmail.com wrote:
> >
> > >I would like to convert this '08 80 4d 19 00 00' into a ROWID
value
> >
> > This not a rowid your posted, but the content of col[1] for a
> > concatenated index of 2 columns.
> >
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
Received on Wed Mar 02 2005 - 07:49:55 CST