Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> logminer question: cannot find sql_undo for deleting record

logminer question: cannot find sql_undo for deleting record

From: lsllcm <lsllcm_at_gmail.com>
Date: Sat, 1 Dec 2007 02:21:09 -0800 (PST)
Message-ID: <037c0b49-1064-417c-893e-7d1e94a43710@d27g2000prf.googlegroups.com>


Hi All,

User says some data of table "TEST" is removed, so I use logminer to mine one log file, and there is one delete sql

delete from "USER1"."TEST" where ROWID = 'AAAIc3AANAAACXsAAO';

But we cannot find the sql_undo record. Can you tell me why this happen? Is it because it is a rollback transaction.

Thanks
Jacky Received on Sat Dec 01 2007 - 04:21:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US