To All
How can I find the rowid value from an index block dump
- SESSION ID:(63.1104) 2005-03-01 14:52:44.230
Start dump data blocks tsn: 4 file#: 34 minblk 45453 maxblk 45453
buffer tsn: 4 rdba: 0x0880b18d (34/45453)
scn: 0x0005.da66b5d9 seq: 0x01 flg: 0x04 tail: 0xb5d90601
frmt: 0x02 chkval: 0x3517 type: 0x06=trans data
Block header dump: 0x0880b18d
Object id on Block? Y
seg/obj: 0xae93d csc: 0x05.da66b5d8 itc: 2 flg: E typ: 2 - INDEX
brn: 0 bdba: 0x880b189 ver: 0x01
inc: 0 exflg: 0
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