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 -> Obtain the ROWID from a index block

Obtain the ROWID from a index block

From: <bobde6_at_hotmail.com>
Date: 1 Mar 2005 07:53:03 -0800
Message-ID: <1109692383.823989.257170@f14g2000cwb.googlegroups.com>


To All

How can I find the rowid value from an index block dump

 Itl           Xid                  Uba         Flag  Lck
Scn/Fsc
0x01 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
0x02 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0005.da66b5d8

Leaf block dump



header address 51161188=0x30ca864
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y kdxconco 2
kdxcosdc 0
kdxconro 1
kdxcofbo 38=0x26
kdxcofeo 8018=0x1f52
kdxcoavs 7980
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8032
row#0[8018] flag: -----, lock: 0
col 0; len 4; (4): c3 07 39 39
col 1; len 6; (6): 08 80 4d 19 00 00
----- end of leaf block dump -----
End dump data blocks tsn: 4 file#: 34 minblk 45453 maxblk 45453

I would like to convert this '08 80 4d 19 00 00' into a ROWID value

Thanks

Bob Received on Tue Mar 01 2005 - 09:53:03 CST

Original text of this message

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