Re: How to read archive logs

Sure.

Use the rowid from DB Log Master as the key to extract the full row from Oracle and build the unique key from the data.

heather_erlank_at_my-dejanews.com wrote:

> We would like to be able to read the Oracle archive logs, and apply the same
> updates to a MS SQL Server database, or a CISAM file. BMC's Patrol DB Log
> Master product will help us to analyze the archive log, but all the updates
> are specified as 'UPDATE tname SET fname = xxx WHERE ROWID = nnn'. Our
> problem is that the Oracle rowid does not give us a unique key into the MS
> SQL Server or CISAM data. Any ideas?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 02 1998 - 22:17:13 CDT