Hi !
This is definitely not a week end question...:)
I have dumped some redo blocks and undo blocks for a
transaction.. Now the part 2. How do i decrypt ?
Any one there to help us?
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800801.0059.67
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=426409604
indexid=0x40012b block=0x0040668c
mark leaf row deleted
key :(9): 04 c3 03 0f 44 03 c2 11 51
keydata/bitmap : (6): 00 40 66 79 00 8f
*-----------------------------
* Rec #0x2 slt: 0x61 objn: 64(0x00000040) objd: 64
tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x01
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800801.0059.68
KDO Op code: DRP xtype: XA bdba: 0x00406754 hdba:
0x004000cf
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 333(0x14d)
*-----------------------------
* Rec #0x3 slt: 0x61 objn: 109(0x0000006d) objd:
109 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x02
Undo type: Regular undo Last buffer split: No
Temp Object: No
Received on Fri Nov 24 2000 - 04:34:06 CST
