Re: Obtain ROWID from redo log (again)

>tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0

It's the "slot: 2"

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Bart Heinsius wrote in message ...


>Hi,

>

>Thanks to an earlier reply in this group, I can now find the block and

>file number from the DBA in the redo log.

>

>Can anyone tell me where the row number is listed so that I can

>compose the rowid?

>

>

>REDO RECORD - Thread:1 RBA: 0x099d05.00000003.0010 LEN: 0x019f VLD:

>0x01

>CONTINUE SCN scn: 0x01c0.7290d20d 04/05/02 20:33:29

>CHANGE #1 CLASS:  7 DBA: 0x01000002 INC: 0x00000001 SEQ: 0x0000a38c

>OPCODE 5.2

>ktudh redo: slt: 0x002d sqn: 0x00000092 flg: 0x0012 siz: 175 fbi: 0

>            uba: 0x01000300.0043.1a

>CHANGE #2 CLASS:  8 DBA: 0x01000300 INC: 0x000019a1 SEQ: 0x0000001a

>OPCODE 5.1

>ktudb redo: siz: 175 spc: 3795 flg: 0x0012 seq: 0x0043 rec: 0x1a

>            xid: 0x0000.02d.00000092

>ktubl redo: slt: 45 rci: 0 opc: 11.1 obj: 14 tsn: 0

>            dba: 0x00000000 prev ctl uba: 0x01000300.0043.19

>prev ctl max cmt scn: 0x0000.4390cd09 prev tx cmt scn: 0x0000.4390cd0a

>KDO undo record:

>KTB Redo, op: L  itl: xid: 0x0000.02b.00000092 uba: 0x01000300.0043.19

>                      flg: C---    lkc:  0     scn: 0x01c0.727a7c29

>

>KDO Op code: URP  xtype: XA  bdba: 0x01000035  hdba: 0x01000034

>itli: 1  ispac: 0  maxfr: 4863

>tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0

>ncol: 11 nnew: 10 size: 0

>col  1: [ 6]  52 53 5f 31 5f 31

>col  2: [ 1]  80

>

>Thanks already,

>Bart