Re: Logminer behavior

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 8 Feb 2005 17:44:20 -0800
Message-ID: <qNOdndjik-9995TfRVn-3w@comcast.com>

"mansi" <mansi1704_at_yahoo.com> wrote in message news:98d465518d08f4cc6e6e984c842b41bf_at_localhost.talkaboutdatabases.com...
> I am trying to install and use Logminer on 8i oracle vision database. I
> created the a dictionary on a flat file, set the redo logs and started the
> logminer session using the dictionary file.
>
> I updated a table PO_VENDORS from the ERP application (front end), when I
> query the using the sql
>
> select * from v$logmnr_contents where
> seg_name ='PO_VENDORS'
>
> I only get the lastest change , not my previous updates on different
> records.
>
> I tried quering for the SCN of the previous updated but no records
> returned.
>
> Thanks in advance for the responses.
>

Did you add the archive logs to consider? Jim Received on Tue Feb 08 2005 - 19:44:20 CST