Re: reverse update statement

From: <epipko_at_gmail.com>
Date: 17 Oct 2005 16:46:37 -0700
Message-ID: <1129592797.937302.244070@g44g2000cwa.googlegroups.com>

Doug,
I've never used LogMiner before.
I understand that I have to start it and point it to the arch log? Then I will be able to use V$LOGMNR_CONTENTS view to see the undo data?

So, in my case the arch log file is: esst_archive_11542.arc Is this what I need to do:

EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => 'esst_archive_11542.arc', - OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.START_LOGMNR( -
DICTFILENAME => 'orcldict.ora', -
STARTTIME => TO_DATE('17-Oct-2005 10:00:00', 'DD-MON-YYYY HH:MI:SS'), - ENDTIME => TO_DATE('17-Oct-2005 10:00:00', 'DD-MON-YYYY HH:MI:SS'));

SELECT SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS WHERE USERNAME = 'my_user' AND SEG_NAME = 'SALES_ORDER_DETAIL';

Please reply as it is urgent,
Eugene Received on Mon Oct 17 2005 - 18:46:37 CDT