Oracle LogMiner question

From: Sami Zeitoun <samizn_at_walla.co.il>
Date: 16 Jun 2004 02:56:26 -0500
Message-ID: <e0c648ba9aa21039ea10f577f2dcb646$1@www.orafaq.net>

Post for FREE via your newsreader at post.usenet.com ****

I posted this message couple of minuts ago but I can't find it anywhere!! here it's again:

Does anyone know how can I get a unique identifier for a redo record in the LogMiner??

I tried to run the following SQL statemnet:

select operation,sql_undo,SCN from v$logmnr_contents where operation IN ('INSERT','DELETE','UPDATE','START','COMMIT','ROLLBACK'); I expected to get a unique number (SCN) for each record returned, but as I see now this SCN is not unique... sometimes I got more than one record with the same SCN!!

Can anyone help me??


<CENTER><p>
<table border=0 width=600 cellspacing=0 cellpadding=0><tr>
<TD VALIGN="TOP"><IMG SRC="../../img/title5.gif"></td>
<td VALIGN="MIDDLE" background="../../img/title6.gif"

WIDTH=600><center><font face=arial size=-2><B>
  HOME |
  ASK QUESTION |
  ADD FAQ |

<A HREF="../../supsearc.htm">SEARCH</A> | <A HREF="../../supemail.htm">E-MAIL US</A></B></FONT></td>
<TD VALIGN="TOP" ><IMG SRC="../../img/title7.gif"></td></tr>
</table></CENTER>


</BODY></HTML>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Wed Jun 16 2004 - 02:56:26 CDT