Logminer behavior

From: mansi <mansi1704_at_yahoo.com>
Date: Tue, 08 Feb 2005 16:37:19 -0500
Message-ID: <98d465518d08f4cc6e6e984c842b41bf@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. Received on Tue Feb 08 2005 - 15:37:19 CST