Obtaining ROWID from redo log record

From: Bart Heinsius <eombah_at_hotmail.com>
Date: 22 May 2002 03:07:17 -0700
Message-ID: <f611b2fd.0205220207.17e51532@posting.google.com>

Hi,

I'm an Oracle novice so please excuse any dumb questions I may ask. My site is running 7.3.3.6.0.

Can anyone help me with obtaining the rowid of the record that was updated? The redo log contains:

CHANGE #3 CLASS: 1 DBA: 0x01000035 INC: 0x00000811 SEQ: 0x00004a78 OPCODE 11.5 KTB Redo, op: F xid: 0x0000.02a.00000092 uba: 0x01000300.0043.1b Block cleanout record, scn: 0x01c0.7290d20e, entries follow...   itli: 1 flg: 2 scn: 0x01c0.7290d20e
KDO Op code: URP xtype: XA bdba: 0x01000035 hdba: 0x01000034

itli: 1  ispac: 0  maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 1 ckix: 0
ncol: 11 nnew: 10 size: 0
col  1: [ 6]  52 53 5f 31 5f 32
col  2: [ 1]  80
col  3: [ 2]  c1 03
col  4: [ 3]  c2 5a 3f
col  5: [ 6]  c5 14 17 0a 24 4d
col  6: [ 3]  c2 05 31
col  7: [ 4]  c3 54 0d 5b
col  8: [ 4]  c3 02 3a 40

col 9: [ 1] 80
col 10: [ 2] c1 03

Thanks already,
Bart Received on Wed May 22 2002 - 05:07:17 CDT