Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtain the ROWID from a index block

Re: Obtain the ROWID from a index block

From: <bobde6_at_hotmail.com>
Date: 2 Mar 2005 01:28:17 -0800
Message-ID: <1109755697.282604.253490@z14g2000cwz.googlegroups.com>


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 - 03:28:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US