Oh, yes, you are correct, I forgot what I mentioned is the EXACT SQL. -- Kamus <kamusis@xxxxxxxxx> Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org On Mon, Jul 2, 2012 at 9:59 PM, Alex Fatkulin <afatkulin@xxxxxxxxx> wrote: > No you can't, redo does not store SQL statements. Logminer parses and > interprets the redo into SQL but these are not the same SQLs which > resulted in the data changes. > > On Mon, Jul 2, 2012 at 9:49 AM, Leyi Kamus Zhang <kamusis@xxxxxxxxx> > wrote: > > columns, so yes, I think I can find the exact SQL text by Logminer (from > > SQL_REDO), but it's really complicated when doing it in a product system. > > > > -- > Alex Fatkulin, > http://afatkulin.blogspot.com > > Enkitec, > http://www.enkitec.com > -- //www.freelists.org/webpage/oracle-l