I am trying to find who deleted certain rows fro a table. So I dumped the right logfile with 'layer 11 opcode 3' option. I can see the information about deleted rows, but where is it stored .. whodunit??
Here is a partial listing ... the objectid is 29230 as seen from objn value
--------------------------------------------------------------------------------
REDO RECORD - Thread:1 RBA: 0x0013de.0004a4d4.0088 LEN: 0x0118 VLD: 0x01
SCN: 0x0010.61152c4f SUBSCN: 1 03/25/2003 11:59:02
CHANGE #1 TYP:0 CLS:74 AFN:2 DBA:0x0080671f SCN:0x0010.61152c4f SEQ: 1 OP:5.1
ktudb redo: siz: 156 spc: 4728 flg: 0x0022 seq: 0x093e rec: 0x22
xid: 0x001d.016.00003c57
ktubu redo: slt: 22 rci: 33 opc: 11.1 objn: 29230 objd: 29230 tsn: 31
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x0080671f.093e.1c
KDO Op code: IRP row dependencies Disabled
xtype: XA bdba: 0x07d05920 hdba: 0x07d0590c
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3) size/delt: 44
fb: --H-FL-- lb: 0x1 cc: 5
null: -----
col 0: [10] 61 62 63 5f 66 61 6d 5f 6c 61
col 1: [10] 41 42 43 20 46 61 6d 69 6c 79
col 2: [ 4] 48 50 49 56
col 3: [ 1] 4c
col 4: [11] 4c 6f 73 20 41 6e 67 65 6c 65 73
CHANGE #2 TYP:0 CLS: 1 AFN:31 DBA:0x07d05920 SCN:0x0010.6115216c SEQ: 1 OP:11.3
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x0080671f.093e.22
KDO Op code: DRP row dependencies Disabled
xtype: XA bdba: 0x07d05920 hdba: 0x07d0590c
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3)
--------------------------------------------------------------------------------
I want to see if I can decode it from the dump, logminer is my last resort. I could learn some more from decoding the dump too.
Thanks in advance
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2